MS SQL Server - max degree of parallelism Option

Author

max degree of parallelism Option

Kay

2005-10-28, 11:23 am

Dear all,

What is the ideal value for "max degree of parallelism" if we have very long
running queries which eat up lots of resources in peak hours.

We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
DBA suggests it to set it to 1.

Need your expert opinion.

Kay

JXStern

2005-10-29, 3:23 am

On Fri, 28 Oct 2005 21:12:47 +0500, "Kay" <CallDBA@hotmail.com> wrote:
>What is the ideal value for "max degree of parallelism" if we have very long
>running queries which eat up lots of resources in peak hours.
>
>We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
>DBA suggests it to set it to 1.
>
>Need your expert opinion.

If you have hyperthreading turned on, you may have 8!

Well, y'know, I guess it's obvious, but you don't really want to have
long-running queries during peak hours, do you? There are various
tuning things you can do, but that's more a matter of design and
operations management.

J.

Sponsored Links