Wednesday, March 21, 2012

Processor Queue - Weird

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

No comments:

Post a Comment