The affinity I/O mask option binds the SQL Server disk I/O to a specified subset of CPUs.
Windows can better evaluate the system's handling of processes. For example, on an 8-CPU server running two instances of SQL Server (instance A and B), the system administrator can use the affinity mask option to assign the first set of 4 CPUs to instance A, and the second set of 4 to instance B.
|