PLE counter

• bobrooney.81

  SSC-Addicted

  Points: 432

  More actions

  May 21, 2022 at 7:56 am

  Go to Answer

  #4036625

  Hi All,

  Would like know of why Page life expectancy counter is no more a good metric to tell SQL Server needs more memory?

  What value to be considered as good or bad?

  Thanks,

  Bob

   

   

• Jeff Moden

  SSC Guru

  Points: 1001425

  More actions

  May 22, 2022 at 4:41 am

  Answer

  #4036997

  See the following article by Brent Ozar and the links he has for some of Paul Randal's articles on the subject.

  https://www.brentozar.com/archive/2020/06/page-life-expectancy-doesnt-mean-jack-and-you-should-stop-looking-at-it/

   

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
  "Change is inevitable... change for the better is not".
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  Intro to Tally Tables and Functions

• bobrooney.81

  SSC-Addicted

  Points: 432

  More actions

  May 22, 2022 at 12:27 pm

  #4037123

  Thanks Jeff.