Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Correct Affinity Mask and Affinity I/O Mask Overlap

This rule checks whether the instance of SQL Server has one or more processors that are assigned to be used with both the affinity mask and the affinity I/O mask options. On a computer that has more than one processor, the affinity mask and the affinity I/O mask options are used to designate which CPUs are used by SQL Server. Enabling a CPU with both the affinity mask and the affinity I/O mask can slow performance by forcing the processor to be overused.

When you specify either the affinity mask or the affinity I/O mask options, you should specify both, but only enable each CPU no more than once.

Do not enable the same CPU in both the affinity mask option and the affinity I/O mask option. The bits that correspond to each CPU should be in one of the following states:

  • 0 in both the affinity mask option and the affinity I/O mask option

  • 0 in the affinity mask option and 1 in the affinity I/O mask option

  • 1 in the affinity mask option and 0 in the affinity I/O mask option

Community Additions

ADD
Show:
© 2015 Microsoft