UA-44032151-3 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 http://support.microsoft.com/kb/2845380.

 

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 http://support.microsoft.com/kb/2863256 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 http://blogs.msdn.com/b/sqlreleaseservices/

 

 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:

    blogs.msdn.com/…/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