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

http://support.microsoft.com/kb/2969896

 

New Trace flag to fix cardinality issues

http://support.microsoft.com/kb/2952101

 

Here are the relevant KBs for SQL Server 2012 Service Pack 2 Cumulative Update 2:

 Fix for SSIS that impacts DIXF

http://support.microsoft.com/kb/2991528

 

Fix for Always On

http://support.microsoft.com/kb/2987293

 

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.  support.microsoft.com/…/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