Purpose

The purpose of this article is to teach you the process of configuring the maximum number of worker threads using in Microsoft SQL Server 2000.

To Configure the Maximum Number of Worker Threads

Maximum worker threads option is used to configure the number of worker threads available to Microsoft SQL Server processes. SQL Server uses the native thread services of the Microsoft Windows NT 4.0 or Windows 2000/2003 operating system so that one or more threads support each network that SQL Server supports simultaneously; another thread handles database checkpoints; and a pool of threads handles all users. The default setting for max worker threads (255) is best for most systems.

Following steps describe you the step by step details of configuring the maximum number of worker threads:

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

2. Right click registered SQL Server i.e. PC54, and click Processor tab.

3. Select or type a value for Maximum worker threads, the default value is 255.

4. Click OK.