July 2, 2014 at 8:36 pm
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 !:-)
July 3, 2014 at 5:47 am
I'd suggest looking at the wait statistics. It might just be CPU, but sometimes a problem with I/O or memory can show up as CPU. You may also need to look to the VM host to be sure things are running properly there. It might not be SQL Server at all.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply