0

Below is the complete guide to setting SQL Server affinity:

SQL Servers affinity tells the server to use specific processors to perform a certain task.
For example, affinity I/O mask can be used to configure sql server processors affinity to Input output operations.

How to set the affinity in sql server?

SQL Servers affinity on a multiprocessor system can be set by using sp_configure.

If you have set an invalid value as per your processor configuration you get the error below error:
Msg 5832, Level 16, State 2, Line 1
The affinity mask specified does not match the CPU mask on this system.