• Management Pack:  SQL Server
  • MP Version:  6.4.0.0 for SQL Server 2012
  • Released:  9/10/2013
  • Publisher:  Microsoft

Page Life Expectancy Monitor

  • ID:  Microsoft.SQLServer.2012.DBEngine.PageLifeExpectancyMonitor
  • Description:  Page Life Expectancy (s) for 2012 DB Engine
  • Target:  SQL Server 2012 DB Engine
  • Enabled:  Yes

Operational States

Name State Description
DB Engine Page Life Expectancy is ok Success DB Engine Page Life Expectancy is ok
DB Engine Page Life Expectancy is too low Error DB Engine Page Life Expectancy is too low

Overridable Parameters

Parameter Name Default Value Description Override
Interval Seconds 900 Interval Seconds
Threshold 300 Threshold

Alert Details

Monitor State Message Priority Severity Auto Resolution
DB Engine Page Life Expectancy is too low (Error) SQL DB Engine 2012 Page Life Expectancy is too low Medium Critical Yes

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

Page Life Expectancy is number of seconds a page will stay in the buffer pool without references. High page life expectancy means that required data can be found in cache instead of going to hard drive.

Causes

Extremely low Page Life Expectancy values can be an indication of:

Too small memory on the system

Too small memory configured for SQL Server’s use

Poor index design

Resolutions

Check I/O system to verify how it handles the load, if values of Avg. Disk sec/Read and Avg. Disk sec/Write counters for object PhysicalDisk are high (usually higher than 10 msec.), it means your system may overloaded or opportunities exist for query and index improvement.

Buffer Pool can be overloaded because SQL Server works with high amount of tables simultaneously, or full scanning is used in place of search by criteria. Check SQL Server:Access Methods:Full Scans/sec counter to verify the problem.

You may use SQL Server Profiler and browse Showplan Statistics in the Performance category to find an application that cause full scanning.

External References
This monitor does not contain any external references.

See Also for SQL Server Management Pack


Downloads for SQL Server Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED