How to configure the maximum number of worker threads (Enterprise Manager)

How to Install SQL Server 2000

How To

How to configure the maximum number of worker threads (Enterprise Manager)

To configure the maximum number of worker threads

  1. Expand a server group.

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

  3. Click the Processor tab.

  4. In the Maximum worker threads box, type or select a value from 32 through 32767.

    The default value is 255.