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 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.
No comments:
Post a Comment