NickLeonUK

@Esteban_Child_of_the_Sun Thanks for the advice, I'll see if I can get a chance to take it down today, and I'll update here. Thank you for you help!

@Esteban_Child_of_the_Sun & @Norphy Thanks for the advice, unfortunately I couldn't follow very far! Upon opening the activity monitor, it all freezes and I am presented with a lovely error box! - See here: https://pastebin.com/EhYgA5j2

Hi All, First off I'm relatively inexperienced but attempting to resolve this issue myself for a little extra credit from my manager. We're using SIMS, running on a Server 2012 R2 VM with 24GB RAM and an 8 Core Xeon E5 @ 2.1GHz and for the last three weeks plus its been running at 100% of its CPU capacity. The one process hogging a good ~95% of this is the SQL Server. In itself it wouldn't be a problem but users are reporting SIMS being painfully slow, and although I expect our users to exaggerate at least a little, they're talking about 20-30 minutes to generate a single report with only a little data in it. I wanted to just get some additional opinions before we just increase the allocated CPU Power. Is this normal, something you've seen before or something you might have a solution to? Images shown below for additional info: Thanks in advance for any opinions or suggestions! Cheers - Nick