0

Seems like I have problems with parallelism because largest wait types are CXCONSUMER and CXPACKET.

Server has 8 cores. So I am planning to bump up Cost Threshold to 50 and MaxDop to 4

Currently I have default values, which is

  • 5 - cost threshold for parallelism
  • 0 - max degree of parallelism

enter image description here

Mostly, only a couple of databases are used intensively out of all databases we have on instance. Which makes me wonder whether I should implement those changes on a whole instance or only on a couple of databases.

Improve this question

1 Answer 1

Reset to default
0

If you have SQL Server 2017 or above you can enable query store on databases and see the wait stats for each one of the databases so you can decide if you can set maxdop at database scope or at instance scope.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.