开发者

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,

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜