Howdy,
This is a follow on from a previous post
http://www.dbforums.com/t984271.html
And now I have found something interesting :
(1) When I was monitoring the System\Processor Queue locally ( Via a term server login onto the box ) I would see a queue of 3-4. If I monitor the same parameter from a remote PC, I see a Processor Queue of 1 - why?
The box had 1 GB RAM ( SQL used 500 MB and had 250 MB free according to Task manager ).
(2)
I have another almost identical box that has same CPU but twice ammount of RAM ( 2 GB ) but has System\Processor Queue of almost
0 - why?
All other parameters for Disk, IO etc are fine.
Cheers,
SGHow about PROCESS counter during these values?|||sqlguy:
I think this guy (http://groups.google.com/groups?q=%22processor+queue+length%22&hl=en&lr=&ie=UTF-8&selm=YhwfOM4ZTgdHxYwWN9bu3Av1M6%2BQ%404ax.com&rnum=1) knows what he is talking about.sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment