December 10, 2015 at 9:53 am
Like talking religion and politics. If you have a server running NUMA and the script below
(great find by the way) is showing the PLE on all my NUMA to be about 760-800 across all 4, is that a red flag? Avg was actually about 790. Server has about 120 gig for sql server supporting 3rd party app
--http://jongurgul.com/blog/page-life-expectancy/
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT
ple.[Node]
,LTRIM(STR([PageLife_S]/3600))+':'+REPLACE(STR([PageLife_S]%3600/60,2),SPACE(1),'0')+':'+REPLACE(STR([PageLife_S]%60,2),SPACE(1),'0') [PageLife]
,ple.[PageLife_S]
,dp.[DatabasePages] [BufferPool_Pages]
,CONVERT(DECIMAL(15,3),dp.[DatabasePages]*0.0078125) [BufferPool_MiB]
,CONVERT(DECIMAL(15,3),dp.[DatabasePages]*0.0078125/[PageLife_S]) [BufferPool_MiB_S]
FROM
(
SELECT [instance_name] [node],[cntr_value] [PageLife_S] FROM sys.dm_os_performance_counters
WHERE [counter_name] = 'Page life expectancy'
) ple
INNER JOIN
(
SELECT [instance_name] [node],[cntr_value] [DatabasePages] FROM sys.dm_os_performance_counters
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply