Export (0) Print
Expand All
Expand Minimize

SQL Server Properties (Processor Tab)

SQL Server 2000

Use this tab to view or specify the following options.

Options

Processor

Specify the processor you want the instance of Microsoft® SQL Server™ to use.

Maximum worker threads

Specify the maximum number of worker threads available to SQL Server processes.

Boost SQL Server priority on Windows

Specify whether an instance of SQL Server can run at a higher priority than other processes on the same computer. The default is 0, which is a priority base of 7. If you set this option to 1, SQL Server runs at a priority base of 13 in the Microsoft Windows NT® 4.0 or Windows® 2000 scheduler. It is recommended that you change the default only on Windows NT 4.0 or Windows 2000 systems dedicated to SQL Server.

Use Windows NT fibers

Specify that you want an instance of SQL Server to use fibers instead of threads. When using fibers, SQL Server allocates one thread per CPU and then allocates one fiber per concurrent user, up to the max worker threads value. This setting takes effect after you restart the server.

Use all available processors

Specify that you want SQL Server to use all available processors for the parallel execution of queries.

Use processors

Specify the number of processors you want SQL Server to use for the parallel execution of queries.

Minimum query plan threshold for considering queries for parallel execution

Specify the threshold at which SQL Server creates and executes parallel plans. SQL Server creates and executes a parallel plan for a query only when the estimated cost to execute a serial plan for the same query is higher than the value set for this option.

View or change the configured values for the options on this tab. If you change these values, click Running values to see whether the changes have taken effect. If they have not, you must restart the instance of SQL Server for the changes to be implemented.

Running values

View the current running values for the options on this tab. These values are read-only.

See Also

Setting Configuration Options

Show:
© 2015 Microsoft