SQL Server 2012 Service Pack 1 Cumulative Update #6 is available!

The SQL Server team has released CU #6 for Service Pack 1. 

  • KB article: KB #2874879
  • Build # is 11.0.3381
  • This build has 23 fixes by my count. The most interesting (to me) are:
     
    • KB #2877100 : FIX: A memory leak occurs when you enable AlwaysOn Availability Groups or SQL Server failover cluster in Microsoft SQL Server 2012
       
    • KB #2878139 : FIX: "Using 'dbghelp.dll' version '4.0.5'" error is logged in SQL Server 2012 when a statement or job executes the sys.fn_xe_file_target_read_file stored procedure
       

    The latter, most importantly, because it altered the way we approached collecting certain extended event information regarding Availability Groups in SQL Sentry v7.5. Also interesting to note that neither KB indicates these issues are present in the RTM branch. I suspect they won't reflect this until they're updated in a month with similar fixes for RTM. Of course, if you're still on RTM, you should start thinking about migrating to the SP1 branch.

Relevant for builds 11.0.3000 -> 11.0.3380. Do not attempt to install on SQL Server 2012 RTM (any build < 11.0.3000) or any previous version.
 

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, speak frequently at conferences, and write at SQLPerformance and MSSQLTips. In real life I am an architect at Wayfair.

6 Responses

  1. Preeti says:

    What is the latest version of SQL server 2012 and please provide link to download .

  2. AaronBertrand says:

    @Preeti are you trying to download Express Edition? If so latest edition is SP1:
    http://www.microsoft.com/en-us/download/details.aspx?id=35579
    If you're trying to download something else, you need to be more specific. Outside of MSDN subscriptions, you can't really download SQL Server publicly, you get it through volume licensing or from physical media.

  3. Chris Wood says:

    This was another difficult upgrade on an AlwaysOn 2 node cluster. It failed because it could not access the file 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlscriptdowngrade.dll'.
    I was able to rename it and try again but now it complained about C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\perf-SQLSERVERAGENTsqlagtctr.ini. Another file rename and all is now well. Seems just like the problem described in http://support.microsoft.com/kb/2708726/en-us
    The upgrade worked fine on both standalone and normally clustered SQL2012 SP1 servers.
    Connect bug 802143 raised.
    Hope this helps if others get this.  
    Chris

  4. Chuck Humphrey says:

    I am experiencing KB 2878139 and went to download CU 6 for my SQL Server 2012 Standard edition but I see 5 packages for my platform.  Based on the fix name, I am assuming I need SQLServer2012_SP1_CU6_2874879_11_0_3381_x64 but how do I know what the other packages are for so I get the right download?

  5. AaronBertrand says:

    Chuck,
    Yes, the file you want is SQLServer2012_SP1_CU6_2874879_11_0_3381_x64 – the others are poorly named, but they're for more individual components, like data access only, PowerPivot, etc.
    I also highly recommend you get CU8 as opposed to CU6:
    /blogs/aaron_bertrand/archive/2014/01/20/sql-server-2012-service-pack-1-cumulative-update-8-is-available.aspx

  6. CV says:

    Aaron,
    Are you aware of any issues specifically after installing CU 6?
    If there are no known issues then its good otherwise we have to plan for the next CU or upgrading to SP2
    Thanks,