Discussion in 'All SQL Server 2011 Questions' started by nanilbabu, Mar 14, 2011.
how to know the SQL Server Buffer Cache hit ratio? please let me know the query ?
Welcome to the forums.
Are you really referring to the SQL Server 2011 (DENALI) related information here or is it a generic question about Buffer Cache hit ratio?
As per the documentation Buffer-cache hit ratio is:
Buffer Cache: This is the pool of memory pages into which data pages are read. An important indicator of the performance of the buffer cache is the Buffer Cache Hit Ratio performance counter. It indicates the percentage of data pages found in the buffer cache as opposed to disk. A value of 95% indicates that pages were found in memory 95% of the time. The other 5% required physical disk access. A consistent value below 90% indicates that more physical memory is needed on the server.
For information :
Procedure cache is the area of memory where SQL stores your query plans.
Buffer cache is the area of memory where data pages are stored.
Relevant perfmon counters:
Buffer cache hit ratio
Page life expectancy
Separate names with a comma.