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
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
-
Bruce (SqlWork.com) 78,006 Reputation points Volunteer Moderator
2023-11-26T04:06:50.5033333+00:00 -
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
2023-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.
-
ZoeHui-MSFT 41,491 Reputation points
2023-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.