Quote:>Does parellel processing ever occur on a system with a
>single CPU? More specifically, if I issue a query, and
>supply parellel hints, are these ignored on a
I'm using perfomance monitor to measure perfomance of SQL server.
I basically have 2 counters which is Process/SQL srvr/%Processor Time and
At specific moment I can read that Processor/%Processor time/1st processor
is 60%, Processor/%Processor time/2nd processor is 60% and Process/SQL
srvr/%Processor Time is 100%.
My question is how come that sqlsrvr process is eating 100% of CPU time
while both processors are running under 60% utilization?