SQL Server 2012 – install at least CU2

Cumulative Update 2 (CU2) for SQL Server 2012 is a very important patch that you should APPLY AS SOON AS POSSIBLE. There is a serious bug in SP1 that is bloating the registry hive, because msiexec.exe processes keep running, even after rebooting and can use almost 100% of the CPU constantly. Windows will crash and you need to reinstall Windows when the registry hive reaches 2GB in size!

If you look in the Eventlog, the following warnings are logged repeatedly:

EventId: 1004 Source: MsiInstaller Description: Detection of product ‘{A7037EB2-F953-4B12-B843-195F4D988DA1}’, feature ‘SQL_Tools_Ans’, Component ‘{0CECE655-2A0F-4593-AF4B-EFC31D622982}’ failed. The resource” does not exist.

EventId: 1001 Source: MsiInstaller Description: Detection of product ‘{A7037EB2-F953-4B12-B843-195F4D988DA1}’, feature ‘SQL_Tools_Ans’ failed during request for component ‘{6E985C15-8B6D-413D-B456-4F624D9C11C2}’

Read more at:

http://blogs.msdn.com/b/sqljourney/archive/2012/10/25/why-the-registry-size-can-cause-problems-with-your-sql-2012-alwayson-setup.aspx

https://connect.microsoft.com/SQLServer/feedback/details/770630/msiexec-exe-processes-keep-running-after-installation-of-sql-server-2012-sp1

https://support.microsoft.com/kb/2793634

Please contact one of our SQL server consultants if you need help with this issue

Håkan Winther
Twitter: h_winther