How to configure the cost threshold for parallelism (Enterprise Manager)

How to Install SQL Server 2000

How To

How to configure the cost threshold for parallelism (Enterprise Manager)

To configure the cost threshold for parallelism

  1. Expand a server group.

  2. Right-click a server, and then click Properties.

  3. Click the Processor tab.

  4. Under Parallelism, in the Minimum query plan threshold for considering queries for parallel execution (cost estimate) box, type or select a value from 0 through 32767.

    This threshold value is relevant only in symmetrical multiprocessing (SMP) environments.