If you are on SQL Server 2012 SP1 (11.0.3000) and you notice the Windows Application log filling up with MSI Installer events:
- Information / Event ID 10000 / RestartManager / Starting session 0 – YYYY-MM-DDTHH:mm:sss.xxxxxxxxxxxxxxxxxx.
- Information / Event ID 11724 / MsiInstaller / Product: SQL Server 2012 Management Studio — Install started.
- Information / Event ID 11728 / MsiInstaller / Product: SQL Server 2012 Management Studio — Configuration completed successfully.
- Information / Event ID 1035 / MsiInstaller / Windows Installer reconfigured the product. Product Name: SQL Server 2012 Management Studio. Product Version: 11.1.3000.0. Product Language: 1033. Manufacturer: Microsoft Corporation. Reconfiguration success or error status: 0.
- Information / Event ID 1040 / MsiInstaller / Beginning a Windows Installer transaction: {A7037EB2-F953-4B12-B843-195F4D988DA1}. Client Process Id: XXXX.
- Information / Event ID 1042 / MsiInstaller / Ending a Windows Installer transaction: {A7037EB2-F953-4B12-B843-195F4D988DA1}. Client Process Id: XXXXX.
- Information / Event ID 10001 / RestartManager / Ending session 0 started YYYY-MM-DDTHH:mm:sss.xxxxxxxxxxxxxxxxxx.
- Warning / Event ID 1004 / MsiInstaller / Detection of product ‘{A7037EB2-F953-4B12-B843-195F4D988DA1}’, feature ‘SQL_Tools_ANS’, component ‘{0CECE655-2A0F-4593-AF4B-EFC31D622982}’ failed. The resource ” does not exist.
- Warning / Event ID 1001 / MsiInstaller / Detection of product ‘{A7037EB2-F953-4B12-B843-195F4D988DA1}’, feature ‘SQL_Tools_ANS’ failed during request for component ‘{6E985C15-8B6D-413D-B456-4F624D9C11C2}’
If you have the above symptoms, please look at this non-security hotfix KB download: http://www.microsoft.com/en-us/download/details.aspx?id=36215.
Do not install if you have already applied any post SP1 hotfixes, such as SP1 CU1.
Installing that fix will bring your SQL version to 11.0.3128, fix the problem with the MSI installer, and it should drop your CPU consumption a bit as well.