14,500 questions
The only real fix is to give Sqlserver more memory. This alert is warming that pages can not be cached for very long (only 211 seconds in your case).
Low PLE alert
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 63%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chaitanya Kiran
801
Reputation points
I am getting low PLE alert. I checked ad foud that PLE value is 211. But other memory counters(lazywrites, memory grants pending, buffer cache hit ratio etc) are good. How to resolve this issue
SQL Server | Other
3 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com) 78,006 Reputation points Volunteer Moderator2023-11-26T04:06:50.5033333+00:00 -
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator2023-11-26T09:29:27.08+00:00 Is your system experiencing real problems? Are users yelling etc?
Does PLE stay low for a long time? Or is it just an occasional dip?
As Bruce says, it may be that you need more memory. But there could also be queries that needs to tuning. If you have a query that scans a table three times the size of the available RAM, fixing that query could save your day.
You could also read this article from Brent Ozar: https://www.brentozar.com/archive/2020/06/page-life-expectancy-doesnt-mean-jack-and-you-should-stop-looking-at-it/ Quick summary: You should not bother.
-
Chaitanya Kiran 801 Reputation points
2023-11-27T00:33:39.2266667+00:00 PLE stays low for long time. But other memory counters(lazywrites, memory grants pending, buffer cache hit ratio etc) are good. How to resolve this issue
-
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
2023-11-27T07:07:49.99+00:00 Unless you are seeing actual performance problems on the system, just turn off the alert and ignore it.
Sign in to comment -
-
ZoeHui-MSFT 41,491 Reputation points2023-11-27T06:59:42+00:00 Hi @Chaitanya Kiran,
PLE alone don't impact performance of SQL server. There are various performance counter we should consider like Buffer cache hit ratio, disk queue length, checkpoint etc.
As you said that all those are good, you may keep monitoring.
Also check:
https://sqlperformance.com/2014/10/sql-performance/knee-jerk-page-life-expectancy
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.