WMI with SQL 2008

I have a Windows 2003 and 2008 server, both running SQL 2008. All of the APM checks that use WMI to access SQL stats are failing. After digging in a little further with WMI Explorer I realized that the Win32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods class is missing from WMI.

Does anybody know how enable this class for SQL 2008? This only appears to be related to SQL 2008 since I'm having the same problem on both Windows 2003 and Windows 2008 servers. Any SQL 2005 servers on the same server OS's are working fine.

Thanks,
Nick

Find more posts tagged with

sql_2008

wmi_counters

Accepted answers

jiri.tomek

Hello Nick,
Those classes are wrappers for MSSQL performance counters. Can you please check if you have respective performance counters available when you use Perfmon console?

If also those performance counters are missing, you should try to repair installation of SQL server and check if there are all required features selected.

If you have performance counters there, you can try to to change WMI monitors to Performance counter monitors and monitor SQL this way.

All comments

jiri.tomek

Hello Nick,
Those classes are wrappers for MSSQL performance counters. Can you please check if you have respective performance counters available when you use Perfmon console?

If also those performance counters are missing, you should try to repair installation of SQL server and check if there are all required features selected.

If you have performance counters there, you can try to to change WMI monitors to Performance counter monitors and monitor SQL this way.

nkorosi

I really have no idea why WMI is unable to see these counters, but yes, they are available through the performance counters. I've updated the template to use performance counters instead and it seems to be working perfectly. Thanks for the great recommendation!

Nick