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.
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!