A customer recently experienced high processor utilitization and memory usage on their Servicedesk server. Their SQL server gave all of the indications of being disk-bound as well, with high perfmon counters for Average Disk Queue Length (both Read and Write), Buffer Cache Hit Ratio, etc.
Servicedesk 8.0, SQL server 2008.
There was a variety of things found. Key Items were:
This required some extensive troubleshooting. Taking all of the projects and putting them in small groups or in individual IIS application pools helped isolate the problem workflow. Being able to stop some applications helped as well. Once this was complete, we found the problems and remediated them as listed below: