exec sp_configure 'allow updates'		,1
exec sp_configure 'show advanced options'	,1
reconfigure with override

exec sp_configure 'cost threshold for parallelism'  	,0
execute sp_configure 'lightweight pooling'		,0
execute sp_configure 'min memory per query'		,393216
execute sp_configure 'max server memory'		,5662310
execute sp_configure 'min server memory'		,2662310
--For perf runs
--execute sp_configure 'max server memory'		,3000000
--execute sp_configure 'min server memory'		,1000000
execute sp_configure 'max worker threads'		,0
execute sp_configure 'network packet size'		,8192
execute sp_configure 'query wait (s)'			,2147483647
execute sp_configure 'recovery interval (min)',32767                                                                                                                                                        
execute sp_configure 'default trace enabled'		,0
execute sp_configure 'max degree of parallelism'	,256
execute sp_configure 'priority boost'	,1
reconfigure with override

ALTER SERVER CONFIGURATION SET PROCESS AFFINITY NUMANODE=0 to 3; 
reconfigure with override;

ALTER SERVER CONFIGURATION SET SOFTNUMA OFF;
reconfigure with override;
