I am working on SQL server 2008 r2 (windows 2008), DB Server is under CPU pressure ( always 80 to 100% CPU), I am sure there is no Memory pressure.
Quad core( 4 Processors) , RAM 16 GB , (DB size is 400 GB )! recently added another 16 GB RAM so total 32 GB today.
When I stop SQL Server services Then CPU goes 100 to 8%. I am sure this is causing SQL Server only. Here is the KEY word, I disconnected the applications (bcoz its DEV server).
Summary : No application , no SQL jobs , recently refreshed with prod copy! Its SQL dedicated box and single instance. But Its VM machine.
I am struggling with this issues since 1 week .
-- rebuild index, update statistics Still NO USE!
Please help me ! thanks in Advance !:-)