Here comes CU 3 (Build 11.0.3349.0.) for SQLServer 2012 SP1. You can download the same from http://support.microsoft.com/kb/2812412
Similar to CU2 there are some interesting hotfixes which are included in this CU release, and its worth testing it out.
The ones which attracted my attention are –
|2800013||FIX: Access violation when you put a FILESTREAM-enabled database offline in SQL Server 2008 R2 or in SQL Server 2012|
|2803529||FIX: Poor performance in SQL Server 2012 when you run a SQL Server trace|
|2807974||FIX: Error 3456 after you add new file groups to the principal database in a SQL Server 2012 asynchronous database mirroring environment|
|2813214||FIX: CPU spike when there is no load on a server after you install SQL Server 2012 on the server|
|2819662||SQL Server 2012 experiences performance issues in NUMA environments|
The last 2 fixes attracted me a lot, however these are type of issues might not occur for all the environments. The CPU spike fix has a situation like a server with 64 or 128 cores +NUMA and 256GB – 1TB of Memory.These specifications are beyond imagination for small environments and majority of the enterprise(As of now !),so these might not even be a concern for the admin’s.
The decision to test or deploy CU3 for SQL2012SP1 varies from environment – environment and your approach towards CUs.
Thanks for reading and keep watching this space for more.