max degree of parallelism Option

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

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 lon
g
>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.