-1

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**

RoughPlace
  • 121
  • 6

2 Answers2

1

Unless you are installing any specific Microsoft application such as SharePoint or BizTalk, setting MAXDOP = 1 server wide is not a good choice.

There is a good and repeatable way to calculate MAXDOP on SQL Server based on Microsoft best practice.

Also, refer to How It Works: Maximizing Max Degree Of Parallelism (MAXDOP)

My recommendation is to ask your vendor, why they would need it at server instance level as opposed to query level. Also, look into adjusting cost threshold for parallelism which is by default set to 5. Cost threshold of parallelism refers to what the minimum query cost has to be before Parallelism is considered by the optimizer.

Glorfindel
  • 2,205
  • 5
  • 19
  • 26
Kin Shah
  • 62,545
  • 6
  • 124
  • 245
-1

In a highly transactional environment MAXDOP=1 can be an advantage.

It's not really your vendors business what your sever setting is. If their application queries need MAXDOP 1 suggest query hints. Your vendors expectation that you'll make a server wide change for the application is unreasonable.

user41207
  • 107
  • 6