I moved one of my cluster to new one by backup all system databases on the old server, install new cluster on new server ant then restore master, model, msdb on new. New server has near identical hardware configuration, almost... besides number of CPU
During server start I see one error in the error log:
Warning: affinity mask specified is not valid. Defaulting to no affinity.
Use sp_configure 'affinity mask' or 'affinity64 mask' to configure thesystem to be compatible with the CPU mask on the system.
You can also configure the system based on the number of licensed CPUs.
I'd like set default option for affinity from old 255 to 0, I need enable advanced options but I can't
sp_configure 'show advanced options',1
reconfigure with override
Msg 5832, Level 16, State 1, Line 3
The affinity mask specified does not match the CPU mask on this system.
View Complete Post