all groups > sql server programming > may 2006 >
You're in the

sql server programming

group:

ss2k : maxdop matters with 1 cpu ... huh ?


ss2k : maxdop matters with 1 cpu ... huh ? John A Grandy
5/26/2006 7:12:36 PM
sql server programming:
I have a very intensive sproc running on a ss2k instance that starts
throwing intra-query parallelism errors.

If I include OPTION(MAXDOP 1) after each query in the sproc, I no longer get
the errors ...

But the server only has 1 cpu !

What could be going on ?

RE: ss2k : maxdop matters with 1 cpu ... huh ? Omnibuzz
5/26/2006 7:59:01 PM
This might be going on :)

RE: ss2k : maxdop matters with 1 cpu ... huh ? Omnibuzz
5/26/2006 8:02:01 PM
Also,You might have set more than one logical processor for the one physical
AddThis Social Bookmark Button