Find available WMI classes on Windows server

To do that, on the server :

• run "wbemtest"
• click on "connection" and type "root\cimv2"
• click on "enumerate classes" and type "Win32_PerfRawData". Press "ok"

You should see a list of all Win32_PerfRawData WMI classes on the server.

If you wan to find MSSQL WMI information make sure that you see a bunch of "Win32_PerfRawData_MSSQL{Instance}_MSSQL{Instance}" lines. If you don't, you have a problem with the MSSQL Installation.

• Double click on Win32_PerfRawData_MSSQL{Instance}_MSSQL{Instance}GeneralStatistics
• Select the Propertie "_CLASS   _CIM_STRING    Win32_PerfRawData…." and click on "Instances".
• On the new window, you should at least 1 line. If you don't, it means that WMI cannot find any data for your MSSQL Instance. Normaly, wmiadap /f fixes it…
• If you see an instance line, double click on it and it will load the performance counters