471,888 Members | 2,310 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,888 software developers and data experts.

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 2777
"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 YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.