The most recent content from our members.
Greetings, I am attempting to configure the Orion NPM, but running into trouble. In running the configuration manager, when I selected my database the configuration wizard claimed that my database needed to be in either mixed mode or in SQL authentication mode. We only use Windows Authentication, but just for kicks I…
This file is a zip that contains updated SQL templates for APM. These templates have been generated by Solarwinds staff that have expertise in systems administration and monitoring SQL. These templates are an improvement over the existing templates that currently ship with APM 4.0 for two reasons. First, they include…
Hi All, Have just started evaluating SAM 5.01. I have setup some monitors on MS 2 node failover cluster (windows 2008 r2), with SQL 2008 r2 installed. I can connect the virtual cluster interface and have configured the SQL 2005-2008 Perf (SQL) is working fine and all components are detected. The Windows 2008 Failover…
We use SQL Server 2008 Uber Edition (which it is compared to SQL Server 2005) . I ran the query to defragment the indexes. I noticed in SQL Managment Studio that there are options under the Maintenance Plan that deal with maintaining the indexes for optimal performance. Right now I just back up the database and run the…
Hi Everyone, My apologies if this is a overly redundant question, but I haven't been able to find much about this, so here it goes, maybe someone around here with a bit more experience might be able to lend a hand. I run several (20+) servers that run either SQL 2005 or 2008, and each one of these contains anywhere from 1…
Hello, We recently configured ASync DB mirroring for a particular application in our environment. I would like to know if it is possible to use APM or NPM to monitor the status of this SQL mirror. I envision being able to gather stats about the change rate, amount of data transferred, how far behind, and also generate an…
I have created an alert that uses HTML, and SQL, one of the fields we are looking at has the potential to have one, or more elements. If I have the DBA's write a stored procedure to parse out the elements we need can the alerts utilize the Stored Procedure.. and is there a special place that the alerts will pull from to…
I was able to get SQL cluster monitoring setup using several posts, add physical nodes and virtual nodes. Apply SQL templates to them with suitable modifications. For a default instance the templates work fine. For named instance I was able to get a modfied WMI template working but the SQL template just will not work no…
Hello, I am new to all of this and I am wondering what everyone else monitors their SQL Server 2008 with?
Recently upgraded our NPM environment to run the SQL database on a dedicated server. So what SQL software can I uninstall from the NPM server? Refer to the screen shot below to see what SQL components are currently installed.
It looks like you're new here. Sign in or register to get started.