Under what circumstance would setting MaxDop to anything other than 1 cause an issue?
-1
votes
2
answers
251
views
we are having continued discussions with our vendor whom is insistent on setting MaxDop to 1
we have performed internal testing and see a general 20% performance improvement by setting this to 4 with cost threshold to 50
we suspect they may be other motives of insisting setting of 1.
I'm unsure what they maybe however.
** EDIT:: to make the question more specific, is there a scenario where by setting maxdop to anything other than 1 cause errors to occur**
- Microsoft Guidance
https://support.microsoft.com/en-us/kb/2806535
- relevant Paul Randall post
http://www.sqlskills.com/blogs/paul/maxdop-configuration-survey-results/
- Brent Ozar on CX packet waits
http://www.brentozar.com/archive/2013/08/what-is-the-cxpacket-wait-type-and-how-do-you-reduce-it/
Asked by RoughPlace
(121 rep)
Jul 15, 2015, 02:37 PM
Last activity: Sep 6, 2023, 11:03 AM
Last activity: Sep 6, 2023, 11:03 AM