sp_configure 'show advanced options',1
go
reconfigure with override
go
alter server CONFIGURATION set process affinity NUMANODE = 0 to 7;
go
reconfigure with override
go
sp_configure 'max server memory',3829760 
go
reconfigure with override
go
sp_configure 'max worker threads',3000
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
