CU3 for SQL2012 SP1 – Couple of interesting hotfixes.

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

(http://support.microsoft.com/kb/2800013/ )

FIX: Access violation when you put a FILESTREAM-enabled database offline in SQL Server 2008 R2 or in SQL Server 2012

2803529

(http://support.microsoft.com/kb/2803529/ )

FIX: Poor performance in SQL Server 2012 when you run a SQL Server trace

2807974

(http://support.microsoft.com/kb/2807974/ )

FIX: Error 3456 after you add new file groups to the principal database in a SQL Server 2012 asynchronous database mirroring environment

2813214

(http://support.microsoft.com/kb/2813214/ )

FIX: CPU spike when there is no load on a server after you install SQL Server 2012 on the server

2819662

(http://support.microsoft.com/kb/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.

Conclusion

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.

2 responses to “CU3 for SQL2012 SP1 – Couple of interesting hotfixes.”

S

March 25, 2013

Does this address the ‘registry bloat’ problem from SP1 at all?

1. Anup
  
  March 25, 2013
  
  CU2 for SP1 had fixes for installer bloating the registry.CU3 will also include that fix as these are cumulative in nature. Are you looking for something specific?

Cloud & SQLSailor