Low PLE alert

Chaitanya Kiran 801 Reputation points
2023-11-26T00:13:40.34+00:00

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
{count} votes

3 answers

Sort by: Most helpful
  1. Bruce (SqlWork.com) 78,006 Reputation points Volunteer Moderator
    2023-11-26T04:06:50.5033333+00:00

    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).

    0 comments No comments

  2. 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.


  3. 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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.