SQL SERVER – What is Page Life Expectancy (PLE) Counter

During performance tuning consultationconsultation, there are plenty of counters and values, I often come across. Today we will quickly talk about Page Life Expectancy counter, which is commonly known as PLE as well.

You can find the value of the PLE by running the following query.

SELECT [object_name],
[counter_name],
[cntr_value] FROM sys.dm_os_performance_counters
WHERE [object_name] LIKE '%Manager%'
AND [counter_name] = 'Page life expectancy'

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.

Now check your system and post back what is this counter value for you during various times of the day. Is this counter any way related to performance issues for your system?

Note: There are various other counters which are important to discuss during the performance tuning and this counter is not everything.

Update: PLE counter should be me 300 or more (OLTP Blueprint – A Performance Profile of OLTP applications)

Update2: Paul has done very technical and informative blog post where he explains the reasons and the correct answer for PLE. Read here.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Scripts
Previous Post
SQL SERVER – Activity Monitor and Performance Issue
Next Post
SQL SERVER – What the Business Says Is Not What the Business Wants

Related Posts

70 Comments. Leave new

Leave a Reply