It’s time to patch SQL Server 2012 installations again. There is one critical data corruption issue, a fix for Always On, SSIS bug that impacts DIXF and a new performance trace flag.
Here are the relevant KBs for SQL Server 2012 Service Pack 2 Cumulative Update 1:
Data corruption bug rebuilding clustered indexes online
New Trace flag to fix cardinality issues
Here are the relevant KBs for SQL Server 2012 Service Pack 2 Cumulative Update 2:
Fix for SSIS that impacts DIXF
Fix for Always On
At this time, the minimum recommendation would be to go to SQL 2012 SP2 CU2 after testing in your environment. The Dynamics AX system requirements guide is being updated to this cumulative update.
I will be writing another blog soon on the new Trace Flag 4139 and it’s impact on our enemy parameter sniffing.
Rod “Hotrod” Hansen
Sr. Premier Field Engineer Dynamics AX