I executed this on one of our SQL Server machines:
EXEC sp_configure 'show advanced options', 1
And then executed
RECONFIGURE. This presented me with the following error message:
The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration.
RECONFIGURE WITH OVERRIDE I can indeed force the configuration. But this is not a solution to the conflict mentioned in the error message.
The values in
sp_configure are as follows:
name minimum maximum config_value run_value affinity I/O mask -2147483648 2147483647 126 126 affinity mask -2147483648 2147483647 126 126
I found some explanation here, but this basically just says "There should not be a conflict", nothing on how to solve it. Could someone knowledgeable please explain to me what this error message actually means and how/if I should try to solve it?
We couldn't find any reason for the setting of conflicting values for
affinity I/O mask and
affinity mask. I changed them back to the default values, 0 for both. After the reconfiguration
affinity mask is set to 0 immediately,
affinity I/O mask apparently requires a restart of the instance.