469,568 Members | 1,358 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,568 developers. It's quick & easy.

Need help on Performance Monitoring

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
Jul 20 '05 #1
1 2699
"Peter Ang" <pe********@yahoo.com> wrote in message news:<3f********@news.starhub.net.sg>...
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


You might find this article useful - it covers the various performance
counters you've mentioned:

http://www.sql-server-performance.co...utor_part4.asp

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Leo | last post: by
1 post views Thread by Evan Smith | last post: by
2 posts views Thread by Peter Kirk | last post: by
2 posts views Thread by Jimmy | last post: by
reply views Thread by Sam Marrocco | last post: by
2 posts views Thread by Shawn B. | last post: by
7 posts views Thread by developer28 | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.