Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Managed Instance
Use this page to view or modify processor options. Processor affinity settings are only enabled when more than one processor is installed.
Enable processors
The grid has the following columns:
| Column | Description |
|---|---|
| Processor | Lists the processors on the server. |
| Processor Affinity | Assigns processors to specific threads to eliminate processor reloads and reduce thread migration across processors. For more information, see Server configuration: affinity mask. |
| I/O Affinity | Binds the SQL Server Database Engine disk I/O to a specified subset of CPUs. For more information, see Server configuration: affinity I/O mask. |
Automatically set processor affinity mask for all processors
Allows the Database Engine to set the processor affinity.
Automatically set I/O affinity mask for all processors
Allows the Database Engine to set the I/O affinity.
Threads
Maximum worker threads
A value of 0 allows the Database Engine 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 Server configuration: max worker threads.