Can't monitor Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryManager

[hehe7nic]

I want to use WMI to monitor the performance of SQL server 2000.  But in some servers I can't find the options of Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryManager in the WMI counters list.

OS is win server 2003 x32 R2 ENT with sp2

SQL server version is SQL server 2000 with sp4

Why the version of OS and SQL server are all the same, but not all of server's SQL Server performance can ben monitored?

[macnugetz · Accepted solution]

WMI Monitor is going to let you monitor the counters that are exposed and running on the machine.