Archive for January 14th, 2008

SQL Counter: Part 12 (Buffer Cache hit ratio) January 14th, 2008

Vinod Kumar

SQL Server Buffer Manager Object -> Buffer Cache Hit Ratio
This counter shows the percentage of pages that are found in SQL Server’s buffer pool without having to incur a read from disk. A well-balanced system will have hit ratio values greater than 80%. The hit ratio ought to be 90% or better for OLTP-type databases.

Continue reading...