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

  • Page Life Expectency is a metric which gives the time duration a data page resided in data cache.

    So if the size of Buffer cache is quite large then the value for PLE will definetly be large. There is nothing wrong in the metrics you are getting on your system.

    If database is highly transactional in nature and/or size of Buffer Cache is relatively small then its value will change and will be less.