Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

SQL Counters in APM 2.0

We recently upgraded to APM 2.0 and setup SQL Server 2005 Database (APM 2.0) on each one of our SQL servers - some are x32 and some are x64. Each one shows 1 up and 7 unknown - SQL Server Port is up and all others are the Unknown. When I hover over the information button I see "Server unavailable using WMI. Unable to connect to "xxxxxx" for WMI access." I am using my domain credentials, so I know it can connect. I did the WBEMTEST from the Orion server to the SQL servers and they connect.

Kind of at a loss at this point.

Find more posts tagged with

Accepted answers

All comments

FormerMember

The template we ship assumes the default SQL instance. If you are using a different SQL instance, you'll need to modify the WMI Query. If that sounds daunting, you can re-create your own version of the template by using AppBuilder, selecting WMI Performance Counter Monitor and browsing to the target SQL Server.

battlepaw

Can I change the default WMI Query use any instance of SQL installed on a machine ala a generic command or do I have to customize it with an app per an instance?

FormerMember

We don't think so because the WMI classes change name based on the name of the SQL instance.

battlepaw

Ok, I have all the processes working correctly now.

All SQL servers are reporting the Processes but I cannot find any of the SQL counters in WMI. I can see them in perfmon on the servers themselves, just not in WMI. This is on all servers - x32/x64/single instance/multi-instance.