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
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!