Hello,

it uses WMI DataSource 1.5.

Try to run a wmiadap /f on the Windows server. The will initialize the WMI counters.

Also, check the Zproperties for the SQL Instance name.

Regards

Can you try to test the WMI request on your MSSQL 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.

Be 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

If you can see the performance counters, double check on Zenoss the MSSQL Instance, the zWinUser and zWinPassword (must be accounts with administrator rights).

Finally, after installind this Zenpack, you must restart Zenoss.

Hope it helps! If you have questions, I'll gladely try to answer them

Regards,

Richard

This is strange... what do you have when you test one of the counter in the template against one of your server in Zenoss ?