Sqlserver - Page Life Expectancy

Page Life Expectancy is number of seconds a page will stay in the buffer pool without references.

SELECT
[object_name],
[counter_name],
[cntr_value]
FROM sys.dm_os_performance_counters
WHERE [object_name] LIKE '%objectname%'
AND [counter_name] = 'Page life expectancy'

No comments: