SQL Server Error Msg 5859 – The current affinity setting specifies the use of more than 64 processors. Before you use sp_configure to change affinity settings, remove these processors by using ALTER SERVER CONFIGURATION.

In this blog post, let’s learn about the error message “5859 – The current affinity setting specifies the use of more than 64 processors. Before you use sp_configure to change affinity settings, remove these processors by using ALTER SERVER CONFIGURATION.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

5859 – The current affinity setting specifies the use of more than 64 processors. Before you use sp_configure to change affinity settings, remove these processors by using ALTER SERVER CONFIGURATION.

Reason for the Error

To be update soon…

Solution

To be update soon…