question

bmurali96 avatar image
bmurali96 asked

How to fix page life expectancy?

Hi, When ever the application can use to update or insert the page life expectancy(PLE) is automatically reducing upto 30 to 0 and after that continuously growing. May I know the reason and any solution for fix this type of issue. Regards Murali
performancesql server 2012sql server 2014
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
JohnM avatar image
JohnM answered
As you insert/update data older pages are being flushed out of the buffer pool in order to accommodate the new inserted/updated pages. A simple solution would be add more memory to the server. A more in-depth solution would be to examine how you are utilizing the buffer pool and if you are doing so effectively. Just some examples, What is your fill factor on your pages? Are you wasting space on the pages with a 50% fill factor? How are your tables structured? Do they maximize page space effectively or is everything wide? Do you have the appropriate indexes in place? Do you have duplicate indexes that can be trimmed? If the server is a VM,is the hypervisor causing memory pressure through ballooning? Are statistics updated appropriately to help ensure query performance? How about index fragmentation? How often is the PLE dropping this low? Was this an isolated incident? If it drops on occasion and then climbs back up to a reasonable (for your environment) level then I'm not sure I'd worry too much about it. You would have to make that determination. This seems to be a good article to look through: https://simplesqlserver.com/2013/08/19/fixing-page-life-expectancy-ple/ Hope that helps!
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.