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 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 | 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.
