Server Properties -> Advance -> Parallelism

I have 4 processors on this server... 8 gb memory... this is the
current setting:

Cost Threshold of Parallelism -> 5
Locks -> 0
Max degree of Parallelism -> 0
Query wait -> -1

I am thinking of changing Max degree of parallelism to 4 (equal to the
number of processors). Is it a good idea or should i leave it to 0???

Thanks, zomer.

zomer,

Changing from 0 to 4 does not buy you much. And if you upgraded the number
of CPUs you might want to change the number instead of it just working. (Not
a strong arguement for me, since you you always review system settings after
an upgrade.)

However, if your 4 processors are really 2 processors that are either
hyperthreaded Xeons or dual-core AMD or Intel, then you should set Max
Degree of Parallelism to the number of "physical" CPUs, which would be 2.

RLF

"zomer" <noneee@gmail.com> wrote in message
news:1173295468.756948.232370@n33g2000cwc.googlegr oups.com...
>
> Server Properties -> Advance -> Parallelism
>
> I have 4 processors on this server... 8 gb memory... this is the
> current setting:
>
> Cost Threshold of Parallelism -> 5
> Locks -> 0
> Max degree of Parallelism -> 0
> Query wait -> -1
>
> I am thinking of changing Max degree of parallelism to 4 (equal to the
> number of processors). Is it a good idea or should i leave it to 0???
>
> Thanks, zomer.
>