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.

Best Practices Recommendations

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.

For More Information

affinity mask Option

See Also

Concepts

Monitoring and Enforcing Best Practices by Using Policy-Based Management