Okay, restarted the process. Things are back to normal. Not sure why was the process taking up the entire CPU.
It’s possible that some query never dies, but never finishes either; so the servers are busy trying to process it over and over again. We should set up some generous timeouts for queries – just a safe thing to do.
Always good to have pages load fast to create the best experience for the user. I was thinking along these lines that we could get all the rest of the content loaded first rather than wait for the demo to load as well. Maybe there isn’t an easy way to do this. But if there is we should take a look.