sp_configure 'max memory', 0, '18G'
sp_configure 'allocate max shared memory', 1
sp_configure 'number of index trips', 0
sp_configure 'number of open databases', 20
sp_configure 'procedure cache size', 0, '1G'
sp_configure 'update statistics hashing', 0, 'on'
sp_configure 'utility statistics hashing', 0, 'on'
sp_configure 'number of histogram steps', 50
sp_configure 'number of sort buffers', 2500
sp_configure 'number of user connections', 100
sp_configure 'compression info pool size', 131072
sp_configure 'max online engines', 8
sp_configure 'min pages for parallel scan', 200000
sp_configure 'number of locks',5000000
sp_configure 'lock hashtable size', 65536
sp_configure 'row lock promotion LWM', 2048
sp_configure 'row lock promotion HWM', 2147483647
sp_cacheconfig 'default data cache', '1G'
sp_cacheconfig 'default data cache', 'cache_partition=8'
sp_poolconfig 'default data cache', '2G', '128K'
sp_poolconfig 'default data cache', '16K', 'wash=8G'
sp_configure 'global async prefetch limit', 10