Monitor buffer cache hit ratio

[jebenson]

Howdy folks!

I am trying to do some baseline performance monitoring on my SQL Server 2000 machine, and have found indtructions that say that one of the important counters to monitor is SQL Server Buffer: Buffer Cache Hit Ratio. However, when I go into Win 2k's System Monitor, I see no option for this counter, or any other SQL Server 2000 counters at all. Am I blind, or is there something I need to do in order to get these counters to display so I can select them for monitoring?

Thanks!

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[TheBugSlayer]

It is a counter that you need to add, once in performance monitor. I will try to (re) figure out how to achieve that and get back to you, if you don't get help from anyone else.

Below are some links that you may find useful.

http://vyaskn.tripod.com/analyzing_profiler_output.htm

http://www.networkcomputing.com/601/601work1.html