Home Forums SQL Server 2012 SQL 2012 - General Page life exceptancey performance couter value not change for a long time RE: Page life exceptancey performance couter value not change for a long time

  • That value changes a lot over time. You can't look at it once and interpret anything from it. You must capture it continually. And, just because it changes doesn't mean you have a problem. It's just an indication of stuff moving out of your memory. You'll have to look at other metrics to determine if that's just a normal part of your load process or an indication of an issue.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning