How to configure the number of processors available for parallel queries (Enterprise Manager)

How to Install SQL Server 2000

How To

How to configure the number of processors available for parallel queries (Enterprise Manager)

To configure the number of processors available for parallel queries

  1. Expand a server group.

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

  3. Click the Processor tab.

  4. Under Parallelism, select the number of processors to execute queries in parallel.

    By default, all available processors are used.