2

Recently I have buffer issue for my SSIS package. When i started to monitor metrics in perfmon i noticed the PLE is nearly 500000. Is it ok to have this huge PLE.

enter image description here

1
  • 2
    You might make the other DBA's jealous. – James Feb 5 '18 at 19:53
2

Page Life Expectancy is simply how long (in seconds) a page will remain idle in the buffer before being removed to make room for another page.

There's no active harm in a very large PLE. It's possible that you've got more memory going to SQL Server than is absolutely required, but that's still not necessarily a bad thing.

Not the answer you're looking for? Browse other questions tagged or ask your own question.