PLE value goes below 100 certain times of the day.

Heisenberg 261 Reputation points
2022-09-20T23:54:26.063+00:00

hello,
I have setup an alert in my sql server to measure PLE value , Alert runs every 15 mins to check if PLE goes below 300 and i have seen certain times of the day PLE values goes as low as 45 , 100. is this concerning?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,924 questions
0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. Olaf Helper 41,571 Reputation points
    2022-09-21T05:22:53.403+00:00

    Is this concerning?

    Depends on the workload & usage of your SQL Server.
    We have a data warehouse, where we load each night several 100 GB from our OLTP system and during this time the PLE goes down; as expected and don't make me worry.

    1 person found this answer helpful.
    0 comments No comments

  2. PandaPan-MSFT 1,901 Reputation points
    2022-09-21T02:30:13.4+00:00

    Hi @Heisenberg ,

    As a traditional standard, PLE should not be less than 300 seconds (5 Minutes). If it's 45,100 which means the memory pressure is very high, you may have to take care of the performance side.

    According to your situation, the first thing should be to check memory allocation. Is it enough amount of size for the SQL Server? If yes, then check the currently executing request, is there any long-running thread that consumes more memory? If yes, then review the currently executing query statement

    Besides you can also use the windows performance monitor to check the disk situation. There are many reasons to cause the I/O problem. It will take some time to find the specific problem.

    Wish you good luck!


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

    0 comments No comments

  3. Erland Sommarskog 102.4K Reputation points
    2022-09-21T21:32:56.713+00:00

    I agree with Olaf. If these alerts coincide with occasions where users log complaints that the system is slow, it's certainly something to dig further.

    On the other hand, if users appears to be content with performance, I am not sure that I would bother. As Olaf says, there can be natural reasons why this happens. Index rebuild, for instance.


  4. PandaPan-MSFT 1,901 Reputation points
    2022-09-22T07:59:08.727+00:00

    Hi @Heisenberg ,
    We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

    0 comments No comments

  5. KMP-8634 1 Reputation point
    2022-09-22T15:17:01.123+00:00

    The clear answer "as always": it depends.

    In my opinion, PLE is a "red herring" these days. In particular, PLE by itself says nothing. Are users complaining or is anything running slower than usual?

    I would look for indications of memory pressure. Before I paste in individual queries here, which again illuminate only a part of the whole, 2 recommendations:

    Hope that helps.

    0 comments No comments