I am trying to determine the cache hit ratio a server running SQL2000 on Windows 2000. When I use DBCC Perfmon command in Query analyser I get a ratio of 99.999. However, when using the Cache-Hit counter through NT's Performance monitor the ratio is around 65.00.
Which am I to believe? The server has 512MB ram, and almost nil activitiy so the DBCC figure made sence to me. Am I somehow misinterprating the Performance Monitors results.
Any clues much appreciated.
Yael
Which am I to believe? The server has 512MB ram, and almost nil activitiy so the DBCC figure made sence to me. Am I somehow misinterprating the Performance Monitors results.
Any clues much appreciated.
Yael