Documentation
-
Server configuration: affinity64 mask - SQL Server
Find out about the affinity64 mask option. See when to use it in SQL Server to bind processors to specific threads.
-
Correct affinity mask & affinity IO mask overlap policy - SQL Server
Learn how to enable a policy that checks whether an instance of SQL Server has one ore more processors that are assigned to be used with both the affinity mask and the affinity I/O mask options for Policy-Based Management in SQL Server.
-
Server configuration: affinity I/O mask - SQL Server
Learn about the affinity I/O mask option. Use it to enhance the performance of SQL Server threads that issue I/Os by binding disk I/O to specified CPUs.