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.
- KB #2877100 : FIX: A memory leak occurs when you enable AlwaysOn Availability Groups or SQL Server failover cluster in Microsoft SQL Server 2012
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,
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,
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
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?
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
@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.
What is the latest version of SQL server 2012 and please provide link to download .