Thanks, but I don't think this is the right query.
currrently, MaxDop is set to 2, but this query reported:
sessionid request_id parallel wanneer
----------- ----------- ----------- -----------------------
374 0 3 2009-11-04 16:31:00
which indicated SQL is using 3 processors ? :crazy:
fyi the server has 4 quadcore CPUs
Wilfred
The best things in life are the simple things