Seems like I have problems with parallelism because largest wait types are
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.