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