Should I change parallelism (MaxDop and Threshold)?
0
votes
1
answer
218
views
Seems like I have problems with parallelism because largest wait types are 
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.
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
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.
Asked by Serdia
(707 rep)
Jul 6, 2021, 10:27 PM
Last activity: Jun 9, 2025, 01:08 AM
Last activity: Jun 9, 2025, 01:08 AM