Export (0) Print
Expand All
Expand Minimize
1 out of 2 rated this helpful - Rate this topic

How to: Configure the Number of Processors Available for Parallel Queries (SQL Server Management Studio)

Use the max degree of parallelism server configuration option to limit the number of processors (up to a maximum of 64) to use in parallel plan execution.

To configure the number of processors available for parallel queries

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Advanced node.

  3. In the Max Degree of Parallelism box, select the maximum number of processors to use in parallel plan execution.

    The default value of 0 uses all available processors. Set max degree of parallelism to 1 to suppress parallel plan generation. Set the value to a number greater than 1 to restrict the maximum number of processors used by a single parallel query execution. If a value greater than the number of available processors is specified, the actual number of available processors is used. If the computer has only one processor, the max degree of parallelism value is ignored.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.