January 12, 2004 at 3:31 am
Dear Forum,
"in the old days", a program used 100% CPU while it was running unless it had to do I/O and wait for Harddisk-access.
Nowadays, on our new HP dual-Xeon Hyperthreading machine, the CPU is not at its max when running my stored procedure (not even a single one of the four virtual CPUs shows 100% usage) and the Harddisk is not busy either. What on earth is my server waiting for ??
January 12, 2004 at 11:20 am
I'd start from analyzing Wait Statistics and Locks.
January 12, 2004 at 12:26 pm
Run select * from sysprocesses where waittime > 0 order by waittime desc to see what SQL Server are waitting for.
How many CPUs do you have? Do you enable Parallel Execution for queries?
January 13, 2004 at 2:05 am
I'd be worried if any of my servers were sitting on 100% cpu. !!! Are your users experiencing wait/timeouts or are you just noticing your server isn't beeing driven flat out any more?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply