One of the servers I'm responsible for now was set up under the wrong license so can only use 40 cores on the server. This has led to an imbalance in the NUMA node schedulers. I'm planning on using
ALTER SERVER CONFIGURATION to fix this, I'm wondering if this is the correct way of doing it and what the potential risks are of running this? From what I've been able to find I don't believe a restart is required, is that correct? Unfortunately I don't have a server I could test this on.
ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 1 TO 10, 17 TO 26, 33 TO 42, 49 TO 58;
SQL Server 2012 Enterprise 4 sockets with 8 cores, 16 logical processors (Intel(R) Xeon(R) CPU E5-4640 0 @ 2.40GHz)
This is not a VM,