Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determining Cache-hit ratio

Status
Not open for further replies.

whool

Programmer
Jan 31, 2002
31
AU
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top