There is a known issue with SQL Server 2012 Service Pack 1 . If you have installed Service Pack 1 not part of a slipstream install, then the registry on your SQL server could reach the 2GB limit and crash your SQL Server.
To avoid this issue for Dynamics products it is highly recommended to install at least Service Pack 1 Cumulative Update 5 for SQL Server 2012 or above because this version addresses some other issues that impact Dynamics.
SQL Service Pack 1 Cumulative Update 6 is the current release.
For those Dynamics customers on SQL Server 2012 Service Pack 1 or above, AX Cumulative Update 7 is released
http://support.microsoft.com/kb/2894115.
There are 2 memory leaks that have been patched that impact Dynamics AX:
http://support.microsoft.com/kb/2881661
http://support.microsoft.com/kb/2895494
I’ve personally seen this at customers with AX 2009 and AX2012.
You can run this query to test for the issue:
select type, sum(pages_in_bytes)/1024.0/1024.00 ‘Mem in MB’, count (*) ‘row count’ from sys.dm_os_memory_objects where type like ‘%MEMOBJ_COMPILE_ADHOC%’
group by type
Read more about this issue at:
http://blogs.msdn.com/b/psssql/archive/2013/07/31/after-applying-service-pack-1-for-sql-server-2012-you-may-encounter-a-known-issue-details-inside.aspx
As with all Microsoft patches, it should be first applied to your test environment before rolling out into your production systems
So, please plan on patching your SQL servers at your earliest opportunity.
