perfmon cache hit ratio

perfmon cache hit ratio

Post by Andr » Sun, 27 Jan 2002 06:41:16

I'm seeing something that I think is unusual in Performance Monitor.  In the
Cache Hit Ration counter, my "Adhoc SQL Plans" consistently have a higher
count than my "Procedure Plans"; about 80 for Procedure and 92 for Adhoc.

I would think since Procedure plans are compiled, I would get a higher hit
ratio here than in Adhoc.  Am I not correct?  If I am correct, what would
this tell me?  Do I need to do something so my sprocs get a higher hit

Thanks, Andre


1. Two different cache-hit-ratio perfmon counters?

Hi all,

I've noticed that there are two Perfmon counters for monitoring cache usage:
"Buffer cache hit ratio" under Buffer Manager, and "Cache hit ratio" under
Cache Manager.

I'm wondering, what's the difference between the two? The buffer ratio is
sitting at 99.98%, while the cache ratio is at 71.5% (the server was
restarted last week, so the first is fairly recent). I'm not worried about
the first one, but the second is wayyy under Microsoft recommendations, and
I'm trying to figure out if this should be a concern. Comparing Page Lookups
to Page Reads (about 9100 to 30) makes me think we're actually hovering
around 99.7%.

I've looked in MSDN and Inside SQL Server but there's very little info
specifically on the Cache ratio counter.

Randy Rabin

2. ADO HELP - AutoNumbers and Adding New Records

3. PerfMon - SQL Buffer - Buffer Cache Hit Ratio

4. wither the checkpoint?

5. help - the cache hit ratio is constantly 0.0

6. HELP! Possible memory problems

7. Why would cache hit ratio be over 100%

8. Delimited Output

9. cache hit ratio!!!

10. cache hit ratio!!

11. Cache Hit Ratio very low.

12. buffer cache hit ratio drops to zero

13. Cache hit ratio '_Total' counter