My brand new Dell Power Edge server PER720, CPU for the last 3 weekends has been running very hard almost 100%. This server has SQL 2012 SP1 installed with 32GB of RAM and an Intel(R) Xeon(R) CPU E5-2640 0 @ 3.30Ghz processor.
During the week the CPU is normal, about 5% on average, however during the weekend starting Sat morning around 9AM, the CPU jumps to 80% to 100%.
Let me also share with you that I have ruled out the following. I don't believe that this is a SQL 2012 issue because I would shut down the SQL engine (and everything related to SQL) when this happens and the CPU would still be running at 80 to 100%. So this is not an out of control SQL process.
OK, before all the DBA's start commenting how could I shut the the SQL engine first please keep in mind two things. This server is not in production and I have tried many other trouble shooting methods before I would ever simply shut down the SQL engine.
I did this to prove a point to the Windows admin that this is not a SQL issue!
To continue, I had the Windows admin check to see if he had any of his applications running. Such as Symantec, Avamar and Disk keeper, he assured me that none of these were running at the time.
So it wasn't doing a virus scan or backup or defraging the drive volumes.
However, I did asked him to shut down the Symantec and disk keepers services to see if the CPU would drop. Unfortunately it did not, finally we would reboot the server, thinking that this would kill the whatever was eating up the CPU.
Well guess what? The CPU would simply go back to the same utilization without a hick-up!
This is where it gets really interesting, mysteriously the CPU would go back to normal (around 5%) all by itself Monday at midday and for the rest of the week.
Ruling out that I have a possessed server, have I missed anything? Could there be some embedded scheduled task stored in the BIOS level? I am at my wits end with this problem and I need some good advise!