Thanks a lot. If it is possible, can you give a little more detail about
that buffer cache hit ratio is application specific? or please kindly direct
me to some recommended literature regarding this issue.




------------
Ray Miao at 2/20/2002 12:34:38 PM

Cache hit ratio is for data cache while buffer cache hit ratio is application specific. You need more memory since cache hit ratio is below 50%.


------------
Lu at 2/20/2002 10:05:50 AM

I ran a NT performance monitoring included serveral SQL specific counters.
I don't understand some of the results. Buffer cache hit ratio in SQL server Buffer Manager is close to 100%. But Cache hit ratio in SQL server Cache Manager is below 50%. Would you please help me in analyzing thoes data?
What is the real difference between those two counters.

Thanks a lot!