TechNet
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
The document is archived and information here might be outdated

How to: Configure the cost threshold for parallelism Option (SQL Server Management Studio)

Use the cost threshold for parallelism option to specify the threshold at which Microsoft SQL Server creates and runs parallel plans for queries. SQL Server creates and runs a parallel plan for a query only when the estimated cost to run a serial plan for the same query is higher than the value set in cost threshold for parallelism.

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

  2. Click the Advanced node.

  3. Under Parallelism, change the CostThresholdForParallelism option to the desired value. Type or select a value from 0 to 32767.

Use the cost threshold for parallelism option to specify the threshold at which SQL Server creates and executes parallel plans for queries. The cost refers to an estimated elapsed time in seconds required to execute the serial plan on a specific hardware configuration. Only set cost threshold for parallelism on symmetric multiprocessors (SMP).

Show:
© 2016 Microsoft