Posted by Gert-Jan Strik on 06/28/05 22:48

The whole idea behind parallelism is to finish sooner by using several
CPU's, so the story that it would in fact slow down individual queries
doesn't make any sense. And the parallelism threshold should prevent
this for queries that have a "obvious" query plan.

Also, without parallelism, SQL-Server also has to decide which CPU
should execute the query plan...

Gert-Jan


kev@earlshilton.com wrote:
>
> Hi,
>
> I have a sql 2000 server with 8 processors, server settings are as
> default. I read on Technet that it is good practise to remove the
> highest no. processors from being used for parallelism, corresponding
> to the no. of NICs in the server. One of our 3rd party developers has
> recommended only allowing one processor to be used as there is a
> performance hit by the server working out which processor to use. Does
> anyone have a definitive answer to this? I suspect he's wrong but I'd
> like some hard evidence if possible, thanks.
>
> Kev.

[Back to original message]