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.