SQL Counter: Part 12 (Buffer Cache hit ratio)

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.
Published 01-14-2008 2:28 PM by vinodkumar
Filed under: , ,

Search

Go

This Blog

Tags

Community

Archives

My Web Site

External Sites

Other Misc Blog Links

Newsletter

Syndication

News


  • Disclaimer: The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

    Follow me on Twitter: vinodk_sql

    Site Counter: Free Hit Counter