ReSearch This KB – SQL DB 2008 Engine Page Life Expectancy is too low

Alert: SQL DB 2008 Engine Page Life Expectancy is too low

Management Pack Name: SQL Server 2008 (Monitoring)

Management Pack Version: 6.4.1.0

Rule or Monitor: Monitor

Rule or Monitor Name: Page Life Expectancy

Rule or Monitor Notes:

This monitor has a warning threshold of 900, and a critical threshold of 300. These settings are fine per http://blog.sqlauthority.com/2010/12/13/sql-server-what-is-page-life-expectancy-ple-counter/.

The alert auto resolves itself after a few minutes.

Issue: This is identified as a critical Alert in monitoring pane but it does not critically affect services.

Resolution: For our environment we changed the critical alert to a warning through creation of an override for all of these objects.

2 thoughts on “ReSearch This KB – SQL DB 2008 Engine Page Life Expectancy is too low

  1. josefehse

    Hi Larry, I was looking into an issue for a customer and stumbled upon this monitor. The funny fact is that I’m seeing very high PLE thresholds (which would mean high PLEs) and getting alerts for that.

    I have exported the MP and checked the monitor type configuration and it looks ok:

    <ConditionDetection ID=”NormalCondition” TypeID=”System!System.ExpressionFilter”>
    <Expression>
    <SimpleExpression>
    <ValueExpression>
    <XPathQuery Type=”Double”>Value</XPathQuery>
    </ValueExpression>
    <Operator>GreaterEqual</Operator>
    <ValueExpression>
    <Value Type=”Double”>$Config/Threshold$</Value>
    </ValueExpression>
    </SimpleExpression>
    </Expression>
    </ConditionDetection>
    <ConditionDetection ID=”ErrorCondition” TypeID=”System!System.ExpressionFilter”>
    <Expression>
    <SimpleExpression>
    <ValueExpression>
    <XPathQuery Type=”Double”>Value</XPathQuery>
    </ValueExpression>
    <Operator>Less</Operator>
    <ValueExpression>
    <Value Type=”Double”>$Config/Threshold$</Value>
    </ValueExpression>
    </SimpleExpression>
    </Expression>
    </ConditionDetection>

    But I still get alerts when the PLE is over 1000, 900+. See this info the Alert Context:

    Time Sampled:
    1/1/2014 10:33:50 AM

    Object Name:
    SQLSERVER

    Counter Name:
    Page life expectancy

    Instance Name:
    MSSQLSERVER

    Value:
    1160

    Not being a SQL expert, at first I thought the higher, the worse, but started to research and it seems there is something fishy about it.

    Also, I don’t think the monitor has a warning threshold. The 900 seems to be the interval.

     

  2. Pingback: Recent updates to ReSearch This #Sysctr #SCOM | Catapult Systems

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.