SQL Server 100% CPU and High Memory Usage
Posted on 2010-09-09
Just installed a SBS 2008 premium box (64bit). Basically run up fine. Did a few updates, whammo, cpu and memory through the roof for SQLservr.exe .
Now I've come across this before and found an article that suggested a command line command that fixed this up. Essentially telling the box to process what it needed to do and be done with it and that worked, fixed it completely. Now I can't find this article. Was a simple command from the command prompt.
Does anyone know what this is?
Cheers In advance