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.

Share this article

Tags: , ,

This entry was posted on Monday, January 14th, 2008 at 14:28 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply