Your SEO optimized title page contents

Severe Performance issue in SQL 2012 with Service Pack 1, Page Life Expectancy drops near 0

If you are running Microsoft Dynamics on SQL Server 2012 with Service Pack 1 installed, we would like to make you aware of a serious performance issue that could impact you.  The symptom is that your Page Life Expectancy drops close to 0 suddenly.


In Performance Monitor it might look like the following:



If you experience this type of behavior on your SQL Server, the fix is in cumulative update 4


HAVING SAID THAT, there is also an issue in cumulative update 4 with SQL Reporting Services that you should install cumulative update 5 to correct.  The KB is for this issue. 

So at a minimum, it would be recommended to install SQL Server 2012 SP1 Cumulative update 5.  You can review all current release for SQL Server at


 Rod "Hotrod" Hansen

Senior Premier Field Engineer


Comments (4)
  1. Rod Hansen says:

    Aaron,  The issue is real and you will also experience a sever hit to disk performance as SQL Server reloads data cache.  In the case of the chart above, this was happening every 2 hours which can be a bad performance hit depending on how much memory you have on SQL (more memory = more to load) and how fast your storage system is.

  2. The counter drops to zero, but is there actually a performance problem? e.g. is the buffer pool really getting cleared, or is it just false alarm reporting? Need the fix in either case but one issue is a lot more drastic than the other.

  3. Tommy Skaue says:

    An interesting article for more in depth read about PLE:…/sql-server-page-life-expectancy.aspx

  4. As a reminder, if you are running Dynamics AX 2012 RTM, you need to deploy the Kernel cumulative Update 5 to support SQL Server 2012 Service Pack 1

Comments are closed.

Skip to main content