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

Improve this question
1
  • 2
    You might make the other DBA's jealous.
    – James
    Feb 5, 2018 at 19:53

1 Answer 1

Reset to default
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.

Improve this answer

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