Page Life Expectancy (PLE) value for each NUMA node

SELECT @@SERVERNAME AS [Server Name]
	,RTRIM([object_name]) AS [Object Name]
	,instance_name
	,cntr_value AS [Page Life Expectancy]
FROM sys.dm_os_performance_counters WITH (NOLOCK)
WHERE [object_name] LIKE N'%Buffer Node%' -- Handles named instances
	AND counter_name = N'Page life expectancy'
OPTION (RECOMPILE);

dm_os_performance_counters

Spread the love