How to configure the cost threshold for parallelism (Enterprise Manager)
SQL Server 2000
To configure the cost threshold for parallelism
- Expand a server group.
- Right-click a server, and then click Properties.
- Click the Processor tab.
- 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.