SIMS Server SQL causing 100%
One of our Servers is performing really poorly, the CPU Utilisation shows SQL running at 100% from around 9am on a morning until 3-4pm on an afternoon. (When the teachers are logged in and using SIMS)
CAPITA are really scratching their heads to try and resolve this one, so I wondered if anyone out there had any thoughts.
The server follows a pattern on our performance graphs showing the CPU spike daily to 100% and stay that way until mid afternoon, clearly showing this is a load issue somewhere.
Any help is really appreciated.
We have tried:
Index Patch (Multiple Times)
Detaching and Re-Attaching Databases
Increasing RAM from 6GB to 8GB as requested by CAPITA
Tech Spec of Server
E6250 @ 2.4GHz Quad Core VM
8GB of RAM
Windows 2008 SP2