Your SEO optimized title page contents

Time to patch SQL Server 2012 Service Pack 2

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

Comments (5)
  1. Nick says:

    Is there any update on the blog post regarding Trace Flag 4139. This flag is now checked in DynamicsPerf, and as such it would be good to have some clarity on how it affects AX (to have this listed as best practice among the other flags)

  2. Ken says:

    I finally came back to this.  Perhaps this is the AlwaysOn hotfix?

    "2982843  FIX: Longer latency for SQL Server 2012 database when you use Service Broker, database mirroring, and AlawysOn"  That's what I get for searching the article using correct spelling and the wrong KB number.

  3. Ken says:

    I still can't find it in the SP2 CU2 fix KB article.…/2983175.  2987293 just isn't there.

  4. Rod Hansen says:

    The KB is still listed in the documentation for the Cumulative update but you are correct the link is not working.  That generally means it's in the process of being updated but I'm not sure in this case.

  5. Ken says:

    Rod, that link for the AlwaysOn fix doesn't work.  I can't seem to find anything in the CU2 Hotfix list relating to AlwaysOn either.  Did they leave that part out?

Comments are closed.

Skip to main content