Purpose

The purpose of article is to teach you the process of configuring the cost threshold for parallelism in Microsoft SQL Server.

Configuring the Cost Threshold for Parallelism

Cost threshold for parallelism option is used to specify the threshold where Microsoft SQL Server creates and executes parallel plans. SQL Server creates and executes a parallel plan for a query only when the estimated cost to execute a serial plan for the same query is higher than the value set in cost threshold for parallelism. 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).

Note: Select or type a value from 0 through 32767.

Following steps describe you the process of configuring the cost threshold for parallelism:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and then click Enterprise Manager.

2. Right click registered server i.e. PC54, then click Properties and click Processor tab.

3. Select or type a value from 0 to 32767 for Minimum query plan threshold for considering queries for parallel execution (cost estimate).

4. Click OK.