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
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
An interesting article for more in depth read about PLE:
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.
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.