Contents
What is good page life expectancy?
As a traditional standard, PLE (Page Life Expectancy) should not be less than 300 seconds (5 Minutes), but actually, that value can fluctuate based on the SQL Server load. Anyway, a buffer is managed by the numa node, and that can be divided into the multiple numa nodes.
What causes page life expectancy to drop?
Things that can make PLE drop: Queries that get large memory grants. Queries that displace large amounts of pages in memory with new ones. Queries that modify many pages and force them to get flushed to disk.
How do I increase the life expectancy of an SQL instance?
Recommended action : If possible, allocate more memory to SQL, or alternately add physical RAM to the server and increase SQL memory allocation. Check what else is running that might be slowing disk access speed. The buffer pool swaps pages out to disk when memory space is needed.
Where can I find ple in SQL Server?
For example, take the PLE value of the node x 1,000 (do this for all the NUMA nodes). Add the values of all nodes, then divide by the total number of NUMA nodes, then divide again by 1,000. This will give you the server PLE.
Where can I Find my Page life expectancy?
You can find your page life expectancy in sys.dm_os_performance_counters using my post on OS Perf Counters. That post will also help you realize how much load you take off of your disks by raising PLE, then you’re really going to start to understand the burning drive picture you find there.
What does page life expectancy ( PLE ) mean?
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…
Where to start with SQL Server Page life expectancy?
That metric made sense in the SQL Server 7/2000 days when it was all that we had, but today, in 2018, we can do better. Start by looking at wait stats – that tells you what SQL Server is waiting on. I don’t care whether PLE is 300 or 3,000 – tell me what you’re WAITING on, SQL Server, and then I’ll go troubleshoot that metric.
What is the value of the page life expectancy counter?
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. The recommended value of the PLE counter is (updated: minimum of) 300 seconds.