Purpose

The purpose of this article is to teach you the process of  configuring the number of processors available for parallel queries.

 Configuring the Number of Processors Available for Parallel Queries

Microsoft SQL Server 2000 provides parallel queries to optimize query execution for computers having more than one microprocessor. By allowing SQL Server to perform a query in parallel by using several operating system threads, SQL Server completes complex queries with large amounts of data quickly and efficiently. By default, all available processors are used.

Following steps describe you the process of configuring the number of processors available for parallel queries:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and then click Enterprise Manager.

2. Right click the registered server i.e. PC54, then click Properties, and click Processor tab.

3. Under Parallelism, check the Use option and select the number of processor.

4. Click OK.