If
MAXDOP is set to
1, set the value to
0, which is the default value, so that SQL uses all available processors.
To change this setting, perform the following steps in
SQL Management Studio:
- Log on to SQL Server Management Studio.
- In Object Explorer, right-click the server and select Properties.
- Click the Advanced node.
- In the Max Degree of Parallelism field, type 0.
These steps allow SQL Server to use all available processors (up to 64).
NOTE: Limit the number of CPUs used by SQL for executing parallel statements if
MAXDOP is set to 0 and you see long wait times on SQL processes with a wait type of
CXPACKET in SQL Management Studio.
For recommendations and guidelines for the
MAXDOP configuration option in SQL Server, see
this Microsoft article.
