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.
Asked
Active
Viewed 159 times
2
-
2You might make the other DBA's jealous. – James Feb 05 '18 at 19:53
1 Answers
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.
RDFozz
- 11,631
- 4
- 24
- 38