Export (0) Print
Expand All
Expand Minimize

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

SQL Server 2000

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.

Show:
© 2014 Microsoft