SQL SERVER DBA, Linux and Azure: Buffer Cache Hit Ratio

Buffer Cache Hit Ratio

Buffer Cache Hit Ratio shows how SQL Server utilizes buffer cache
“Percent of page requests satisfied by data pages from the buffer pool”

SELECT object_name, counter_name, cntr_value
FROM sys.dm_os_performance_counters
WHERE [object_name] LIKE '%Buffer Manager%'
AND [counter_name] = 'Buffer cache hit ratio'

The recommended value for Buffer Cache Hit Ratio is over 90. A lower value indicates a memory problem.

No comments:

Post a Comment