buffer cache hit ratio drops to zero

buffer cache hit ratio drops to zero

Post by Zdenìk Bittne » Thu, 12 Dec 2002 15:38:59



In the Performance monitor - SQL server: Buffer Manager object - a counter
Buffer cache hit ratio = 99%.
But 2 or 3 times in a day it drops to ZERO.
Why? What can be the cause?
Thanks for any idea
Zdenek
 
 
 

buffer cache hit ratio drops to zero

Post by Tibor Karasz » Thu, 12 Dec 2002 15:45:40


Perhaps you are executing some big batch operations at this point? Or some other large scan of
data?
Use Profiler to troubleshoot and try to correlate data.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...


Quote:> In the Performance monitor - SQL server: Buffer Manager object - a counter
> Buffer cache hit ratio = 99%.
> But 2 or 3 times in a day it drops to ZERO.
> Why? What can be the cause?
> Thanks for any idea
> Zdenek