Queries over WMI always returning 0 (CIMV2, SQL Server)
I'm accessing some WMI counters through the network in order to control one instance of SQL Server 2005. I'm using four different classes and properties:
- Win32_PerfFormattedData_MSSQLServer_SQLServerGeneralStatistics (UserConnections)
- Win32_PerfFormattedData_MSSQLServer_SQLServerSQLStatistics (SQLCompilationsPersec)
- Win32_PerfFormattedData_MSSQLServer_SQLServerAccessMethods (PageSplitsPersec)
- Win32_PerfFormattedData_MSSQLServer_SQLServerDatabases (LogFlushesSec)
As far as I know, all these counters SHOULD work and they are essential to monitor how SQL Server is performing his activities. Unfortunately I've achieved different results.
UserConnections works great, but SQLCompilationsPersec and PageSplitsPerSec are returning always 0. LogFlushesSec is not even found.
I've tried to repair WMI repository, but without result:
- cd /d %windir%\system32\wb开发者_Python百科em
- for %i in (*.dll) do RegSvr32 -s %i
- for %i in (*.exe) do %i /RegServer
I must say that all these counters can be accessed and viewed correctly in perfmon (they don't return always 0). The question is why?
Thanks,
精彩评论