solarwinds  |  thwack
in
Search 44,481 posts and 621 resources contributed by 21,475 members or post a topic.

Already Joined? Sign in
Monitoring non-default Instances of SQL Server 2005

rated by 0 users
Not Answered This post has 0 verified answers | 2 Replies | 3 Followers


2 Posts
Points 4
Jcollazo posted on 08-19-2008 6:16 PM
rated by 0 users

I am trying to monitor a server with APM v2 that has the default instance of SQL Server disabled.  There is a non-default instance of SQL Server 2005 running on the server but I don't see in the new v2 SQL Server template (or old SQL Server template for that matter) where you can specify a particular SQL Server instance.   Using the default v2 SQL Server 2005 template gets me healthy indicators for the SQL Server processes but everything else is either reporting unknown or down. 

All Replies


5 Posts
Points 9
rgarrison replied on 08-29-2008 8:15 AM
rated by 0 users

I ran into the same problem.  I eventually discovered you can use the AppBuilder wizard to connect to the SQL server and list the WMI counters per instance name.  Once you get the WQL you can create a new monitor or cut/past the WQL into the monitor within your SQL template.

  • | Post Points: 3

2 Posts
Points 4
Jcollazo replied on 09-05-2008 1:01 PM
rated by 0 users

This worked for me.  Thanks

  • | Post Points: 1
Page 1 of 1 (3 items) | RSS