SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability37
affinity I/O mask
The affinity I/O mask option defines the specific processors on which SQL Server I/O threads can execute. The affinity I/O mask option has a default setting of 0, indicating that SQL Server threads are allowed to execute on all processors.
The affinity I/O mask option is defined according to the same conditions as the affinity mask option. It is best to use the default setting of 0.
The sample in Figure 13 shows the affinity mask and affinity I/O mask options set to 0 (the default) in the Server Properties dialog box.
Microsoft Corporation © 2005