Anil Singh | Code-sample.com

SQL Server Page Life Expectancy (PLE) Counter key performance indicator for those DBAs looking at the overall health of their database instance. Page life expectancy (PLE) -Indicates the number of seconds a page will stay in the buffer pool without references. The recommended value of the PLE counter is (updated: minimum of) 300 seconds. I have seen on busy system this value to be as low as even 45 seconds and on unused system as high as 1250 seconds. Page Life Expectancy is the number of seconds a page will stay in the buffer pool without references. In simple words, if your page stays longer in the buffer pool (area of the memory cache) your PLE is higher, leading to higher performance as every time request comes there are chances it may find its data in the cache itself instead of going to the hard drive to read the data. Some Important point to know about PLE, If you have a server with 64 GB of memory with 56 GB allocated to SQL Server, which means you’re reading abou...