High CPU & RAM Usage on SBS server 2011 Premium running SQL
Posted on 2013-06-12
We have an issue with a SBS server running SBS 2011 Premium with SQL and Exchange.
When we terminate 2 of the 3 Sqlservr.exe in the Task Manager the CPU usage dropped from about 75-85 % average to 10-20% average and the RAM usage drops from 90% to about 50%
The 2 SQL databases are WID/MS##SSEE & SBSMonitoring (by looking inside the SQL Server Configuration manager).
Any suggestion to the high CPU and RAM usage?