Page History
...
Configure your server options for parallelism
Max degree of parallelism
Leave the Max degree of parallelism server configuration option at zero. Note that this configuration may be acceptable for non-OTPL Servers. You can also consider setting the Max degree of parallelism server configuration option at half the number of physical processors on the server up to a max of eight.
Cost threshold for parallelism
Set the Cost threshold for parallelism server configuration option at the default setting of 5.
...