Automatically set processor affinity mask for all processors
Allows SQL Server to set the processor affinity.
Automatically set I/O affinity mask for all processors
Allows SQL Server to set the I/O affinity.
Maximum worker threads
0 allows SQL Server 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.
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 SQL Server must be restarted first.
View the currently running values for the options on this pane. These values are read-only.