Jul 30, 20191 min read

Find SQL Server Page Life Expectancy

-- Page Life Expectancy (PLE) value for default instance

SELECT cntr_value AS [Page Life Expectancy]

FROM sys.dm_os_performance_counters WITH (NOLOCK)

WHERE [object_name] = N'SQLServer:Buffer Manager' -- Modify this if you have named instances

AND counter_name = N'Page life expectancy' OPTION (RECOMPILE);

-- PLE is a good measurement of memory pressure.

-- Higher PLE is better. Watch the trend, not the absolute value.

Recent Posts

-- Find single-use, ad-hoc queries that are bloating the plan cache SELECT TOP(20) [text] AS [QueryText], cp.size_in_bytes/1024 Size_MB...

-- Memory Clerk Usage for instance -- Look for high value for CACHESTORE_SQLCP (Ad-hoc query plans) SELECT TOP(10) [type] AS [Memory...

-- Memory Grants Pending value for default instance SELECT cntr_value AS [Memory Grants Pending] FROM sys.dm_os_performance_counters WITH...