Export (0) Print
Expand All
Expand Minimize

Keep the Affinity Mask Default Value

This rule checks whether the SQL Server setting for the affinity mask is set to 0, which is the default value. The affinity mask option dynamically controls CPU affinity.

For Microsoft Windows 2000 or Windows Server 2003, the default affinity value provides the best performance for SQL Server. We recommend that you keep the affinity mask value set to the default value of 0.

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

Community Additions

ADD
Show:
© 2014 Microsoft