If you are SQL Server 2012 is running with SP1 (11.0.3000) you may encounter the below error messages in the windows application event log and it may cause high cpu pressure on the machine
In Windows Event Viewer
SQL_Tools_ANS component failed, The resource doesn't exist
SQL_Tools_ANS failed during request for component
Event ID 1004 MSIInstaller / Detection of Product {xxxxxx} feature
Event ID 1040 MSIInstaller / Beginning a windows installer transaction {xxxxxxxxx}
Event ID 1042 MSIInstaller / Ending a windows installer transaction {xxxxxxxxx}
Resolution
Please install CU1 on top of SQL Server 2012 SP1, Build No - 11.0.3128 will fix the MSIInstaller issue and high cpu issue.
No comments: