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

SQL Server 2000

To configure the number of processors available for parallel queries

Expand a server group.
Right-click a server, and then click Properties.
Click the Processor tab.
Under Parallelism, select the number of processors to execute queries in parallel.
By default, all available processors are used.

Community Content Add

FAQ