• George M Parker (10/11/2013)


    To know whether your value is good or bad, you have to know what "normal" is. That means that you need to have a baseline value (or steady state as Jonathan refers to it) for PLE and then monitor for situations where it dips below that baseline value.

    This.

    There are very few counters where there's a hard number that's good or bad. Numbers are normal or not normal for your instance.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass