You are hereLongitude Knowledge Book / kb87: SQLServer Cache reports show greater than expected cache hit %

kb87: SQLServer Cache reports show greater than expected cache hit %


By csmith - Posted on 16 November 2009

SQLServer Cache reports display the Buffer Manager:cache hit percentage, rather than the Cache Manager:cache hit percentage.

The values in the report correspond to the "Buffer cache hit ratio" counter of the BufferManager object for the SQLServer instance in Performance Monitor.