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.