Two server configuration options—
maximum degree of parallelism and
cost threshold for parallelism—affect the consideration for a parallel query. Although doing so is not recommended, you can change the default settings for each. For single processor machines, these settings are ignored.
maximum degree of parallelism option limits the number of threads to use in a parallel plan execution. The range of possible values is
32. This value is configured to
0 by default, which allows the Query Optimizer to use up to the actual number of CPUs allocated to SQL Server. If you want to suppress parallel processing completely, set the value to
cost threshold for parallelism option establishes a ceiling ...