sp_configure 'show advanced options', 1
RECONFIGURE
--EXEC sp_configure 'min server memory', 6144 -- 6 GB min, replace with your desired amount here
EXEC sp_configure 'max server memory', 2048 -- 2 GB max, replace with your desired amount here
RECONFIGURE WITH OVERRIDE
sp_configure 'show advanced options', 0