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);