MSSQL - Cache hit ratio in 2005 missing, tried the usual
hi,
If I use perf monitor I get cache ratio around 90%, in opmanager I am getting "N/A".
See no errors in Opman logs (note: red herring below)
wmiadap /f then restart WMI, no errors in MS logs, waited 24 hours.
"Log Cache Hit Ratio" and "Transactions Per Sec" also "N/A"
For "test monitor" I get "The Monitor did not respond to the test request"
Maybe Opmanager thinks SQL2005 is SQL2000?
"MSSQL.MSSQLCache.MSSQLCacheHitRatio" where do I find what WMI class/object is actually used?
Red herring:
Opmanager polls SQL2000 for 2005 classes and visa versa!
SQL2005 server error, "SQLServerCacheManager" does not exist in SQL2005
11:39:19:314 AM 80041010 - Specified class is invalid. Try running 'wmiadap /f'(For Windows XP and 2003) or 'winmgmt /resyncperf'(For Windows 2000) command from the monitored device: While getting WMI data from livepd5.live-org-prod.com for SELECT CacheHitRatio,CacheHitRatio_Base,Name FROM Win32_PerfRawData_MSSQLSERVER_SQLServerCacheManager
SQL2000 server error, "SQLServerPlanCache" does not exist in SQL2005
11:46:48:560 AM 80041010 - Specified class is invalid. Try running 'wmiadap /f'(For Windows XP and 2003) or 'winmgmt /resyncperf'(For Windows 2000) command from the monitored device: While getting WMI data from argon.live-org.com for SELECT CacheHitRatio,CacheHitRatio_Base,Name FROM Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache
If I use perf monitor I get cache ratio around 90%, in opmanager I am getting "N/A".
See no errors in Opman logs (note: red herring below)
wmiadap /f then restart WMI, no errors in MS logs, waited 24 hours.
"Log Cache Hit Ratio" and "Transactions Per Sec" also "N/A"
For "test monitor" I get "The Monitor did not respond to the test request"
Maybe Opmanager thinks SQL2005 is SQL2000?
"MSSQL.MSSQLCache.MSSQLCacheHitRatio" where do I find what WMI class/object is actually used?
Red herring:
Opmanager polls SQL2000 for 2005 classes and visa versa!
SQL2005 server error, "SQLServerCacheManager" does not exist in SQL2005
11:39:19:314 AM 80041010 - Specified class is invalid. Try running 'wmiadap /f'(For Windows XP and 2003) or 'winmgmt /resyncperf'(For Windows 2000) command from the monitored device: While getting WMI data from livepd5.live-org-prod.com for SELECT CacheHitRatio,CacheHitRatio_Base,Name FROM Win32_PerfRawData_MSSQLSERVER_SQLServerCacheManager
SQL2000 server error, "SQLServerPlanCache" does not exist in SQL2005
11:46:48:560 AM 80041010 - Specified class is invalid. Try running 'wmiadap /f'(For Windows XP and 2003) or 'winmgmt /resyncperf'(For Windows 2000) command from the monitored device: While getting WMI data from argon.live-org.com for SELECT CacheHitRatio,CacheHitRatio_Base,Name FROM Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache