sp_configure 'show advanced options',1
go
reconfigure with override
go
alter server CONFIGURATION set process affinity NUMANODE = 0 to 3;

go
reconfigure with override
go
sp_configure 'max server memory',477184

go
reconfigure with override
go
sp_configure 'max worker threads',2000

go
reconfigure with override
go
sp_configure 'priority boost',1
go
reconfigure with override
go
sp_configure 'recovery interval',32767
go
reconfigure with override
go
sp_configure 'remote login timeout',0
go
reconfigure with override
go
sp_configure 'remote query timeout',0
go
reconfigure with override
go
sp_configure 'lightweight pooling',1
go
reconfigure with override
go
sp_configure 'max degree of parallelism',1
go
reconfigure with override
go
sp_configure 'default trace enabled',0
go
reconfigure with override
go
sp_configure 'Agent XPs',0
go
reconfigure with override
go
sp_configure 'backup compression default', 1
go
reconfigure with override
go
sp_configure 'automatic soft-NUMA disabled', 1
go
reconfigure with override
go
