Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Correct Affinity Mask and Affinity I/O Mask Overlap

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft