SQL Server Properties (Processor Tab)
Use this tab to view or specify the following options.
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.
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.
View the current running values for the options on this tab. These values are read-only.