| title | Server Properties (Processors Page) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/14/2017 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| f1_keywords |
|
|
| ms.assetid | cc1581a2-492b-41f0-bda5-17909b65c4f7 | |
| caps.latest.revision | 25 | |
| author | BYHAM | |
| ms.author | rickbyh | |
| manager | jhubbard |
Use this page to view or modify your processor options. Processor affinity settings are only enabled when more than one processor is installed.
Processor Affinity
Assigns processors to specific threads to eliminating processor reloads and reduce thread migration across processors. For more information, see affinity mask Server Configuration Option.
I/O Affinity
Binds [!INCLUDEmsCoName] [!INCLUDEssNoVersion] disk I/Os to a specified subset of CPUs. For more information, see affinity Input-Output mask Server Configuration Option.
Automatically set processor affinity mask for all processors
Allows [!INCLUDEssNoVersion] to set the processor affinity.
Automatically set I/O affinity mask for all processors
Allows [!INCLUDEssNoVersion] to set the I/O affinity.
Maximum worker threads
0 allows [!INCLUDEssNoVersion] to dynamically set the number of worker threads. This setting is best for most systems. However, depending on your system configuration, setting this option to a specific value sometimes improves performance. For more information, see Configure the max worker threads Server Configuration Option.
Boost SQL Server priority
Specifies whether [!INCLUDEssNoVersion] should run at a higher [!INCLUDEmsCoName] Windows scheduling priority than other processes on the same computer. For more information, see Configure the priority boost Server Configuration Option.
Use Windows fibers (lightweight pooling)
Use Windows fibers instead of threads for the [!INCLUDEssNoVersion] service. Note that this is only available in Windows 2003 Server Edition. For more information, see lightweight pooling Server Configuration Option.
Configured Values
Displays the configured values for the options on this pane. If you change these values, click Running Values to see whether the changes have taken effect. If they have not, the instance of [!INCLUDEssNoVersion] must be restarted first.
Running Values
View the currently running values for the options on this pane. These values are read-only.