I was wondering if the CPU is the bottleneck. Hence I used the Performance
Monitor to look up some values. Here are the results.
Counter Scale Average Maximum
Minimum
%Disk Time 1 2.74 24.932
0
Current Disk Queue Length 10 0.090 6 0
Buffer cache hit ratio 1 99.752 99.752
99.751
%Processor Time (Total) 1 2.307 9.688
0.313
%Processor Time (sqlserv) 1 1.218 7.188 0
Processor Queue Length 10 6.960 11 5
The thing that puzzles me is that the Processor Time is quite low but the
Processor Queue Length is very high. Why is the processor processes queuing
up when the processor not bogged down ? I would assume both values to be on
the high side. Is the high buffer hit ratio an indicator that the CPU is
waiting for some reads from the buffer before processing the next process?
The users often run reports on historical data. That might be the reason for
the high buffer hit rates.
Am I monitoring the wrong values ?
Any advise would be very much appreciated and thanks in advance.
Pit