Hello,
I have a server with 4 NUMA processors with 20 cores each for a total of 80 logical processors. I've been reading that affinity mask (64) is going to be deprecated and I should be using ALTER SERVER CONFIGURATION SET PROCESS AFFINITY.
Can someone help me out with this? I've been Googling my head off most of the day and have found many, many articles about the syntax of this command. But I have yet to find much on WHY it should be set to a particular value, etc.
Does anyone have suggestions on how to set this? Or if I even need to change it. Currently CPU configuration on SQL Server is default.
Oh yeah, we're running Windows Server 2008 R2 Enterprise and SQL Server 2008 R2.