• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 436
  • Last Modified:

maximum degree of parallelism risks/caveats / sql server 2008

What are the risks/caveats of modifying the maximum degree of parallelism? We've just upgraded some hardware and there are some queries that actually got slower. I am thinking about setting the maximum degree of parallelism to 1 as this is an OLTP system. How impactful is it to toggle back-n-forth to view the impact? Please just consider the variables provided. Suggesting others is fine.

I'm hoping someone with experience with this provides some feedback.
1 Solution
there are opinions on this topic here:

The majority of OLTP activity should fall under the 'cost threshold for parallelism'
see: http://msdn.microsoft.com/en-us/library/ms181007.aspx
which you can raise to force most activity below that.

Those that exceed that threshold might not really be classic OLTP (e.g. business intel) and parallelism may be appropriate - or those queries need rethinking/tuning.

reference in general:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now