PLE and NUMA

• tcronin 95651

  SSCertifiable

  Points: 6735

  More actions

  December 10, 2015 at 9:53 am

  #323372

  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