I have a software called iCare running on my SBS 2008. It is a healthcare software.
Runs on IIS and SQL Express 2008 R2 for database.
The process sqlserv.exe occupies around 50% of the CPU on most occasions and keeps going upto 100% CPU every few minutes. I think this happens when a query is run by the users.
In particular there is a module called Add Activity in the software which freezes 8 times out of 10 and comes back with an error SQL Exception. This is when the Silverlight goes round in circles and circles and throws this exception.
I think its not right for the process to occupy that much CPU. The database goes very slow and its very frustrating. where do I start? I am not great at SQL.