Post reply

buffer_node_page_life_expectancy

  • February 19, 2019 at 10:12 pm

    #382766

    We have extended event session to monitor buffer_node_page_life_expectancy on our production server which is having 64GB RAM out of which 58 is assigned to SQL but the buffer_node_page_life_expectancy is showing at 700. I understand the value is in Milliseconds and seems too low .

    Can experts please advise?

     I have also checked Buffer Cache Hit Ratio which is very high and Lazy Writes\Sec which is low. This looks normal as per my understanding. Please correct me if I am wrong.

  • February 19, 2019 at 10:33 pm

    #2022450

    Rechana Rajan - Tuesday, February 19, 2019 10:12 PM

    We have extended event session to monitor buffer_node_page_life_expectancy on our production server which is having 64GB RAM out of which 58 is assigned to SQL but the buffer_node_page_life_expectancy is showing at 700. I understand the value is in Milliseconds and seems too low .

    Can experts please advise?

     I have also checked Buffer Cache Hit Ratio which is very high and Lazy Writes\Sec which is low. This looks normal as per my understanding. Please correct me if I am wrong.

    You can read this -- https://www.sqlskills.com/blogs/paul/page-life-expectancy-isnt-what-you-think/.
    Set up perfmon and capture the counters and do some analysis you can get an idea. Most of the time code will be the issue, try capture the running queries as well.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply