You are currently offline, waiting for your internet to reconnect

The 'affinity mask' and 'affinity I/O mask' configuration should not conflict

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

SUMMARY
The 'affinity mask' and 'affinity I/O mask' configuration values of SQL Server should not conflict. Performance may suffer if you choose to affinitize a processor for both SQL Server worker thread scheduling and for I/O processing. Therefore, you should ensure that the configuration values are not set for the same processor. The same recommendation applies to the 'affinity64 mask' and 'affinity64 I/O mask'.
MORE INFORMATION
If these configuration values do conflict, when you try to run the RECONFIGURE command, the following error will occur:

Msg 5834, Level 16, State 1, Line 1
The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration

You would have to execute RECONFIGURE WITH OVERRIDE to allow these settings to be used for the next restart.

For more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product, see the following table:

Rule softwareRule titleRule descriptionProduct versions against which the rule is evaluated
SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA)





Conflicting affinity mask settings detected






The SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA) provides a rule to detect a conflict with the 'affinity mask' and 'affinity I/O mask' configuration. The SQL Server 2008 R2 BPA supports both SQL Server 2008 and SQL Server 2008 R2.

If you run the BPA tool and encounter an Error with the title of Engine - Conflicting affinity mask settings detected, then your SQL Server 2008 or SQL Server 2008 R2 installation has a has a conflict with the 'affinity mask' and 'affinity I/O mask' values (and 'affinity64mask' and 'affinity64 I/O mask') as found in sys.configurations (the "value_in_use"). BPA uses SMO to find the run value of this configuration.
SQL Server 2008
SQL Server 2008 R2







SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA)





Conflicting affinity mask settings detected





The SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA) provides a rule to detect a conflict with the 'affinity mask' and 'affinity I/O mask' configuration.

If you run the BPA tool and encounter an Error with the title of Engine - Conflicting affinity mask settings detected, then your SQL Server 2008 or SQL Server 2008 R2 installation has a has a conflict with the 'affinity mask' and 'affinity I/O mask' values (and 'affinity64mask' and 'affinity64 I/O mask') as found in sys.configurations (the "value_in_use"). BPA uses SMO to find the run value of this configuration.
SQL Server 2012








Properties

Article ID: 2157114 - Last Review: 04/02/2012 22:43:00 - Revision: 2.0

Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Enterprise X64 Edition, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Workgroup Edition, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 R2 Datacenter, Microsoft SQL Server 2008 R2 Developer, Microsoft SQL Server 2008 R2 Enterprise

  • KB2157114
Feedback
html> style="display:none;" onerror="var m=document.createElement('meta');m.name='ms.dqp0';m.content='true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> ndex -->
Uruguay - Español
대한민국 - 한국어
España - Español
Paraguay - Español
Venezuela - Español
://c1.microsoft.com/c.gif?DI=4050&did=1&t="> var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" d')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> >