EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'max server memory (MB)';
EXEC sp_configure 'min server memory (MB)';


EXEC sp_configure 'max server memory (MB)', 10240; -- 10GB in MB
EXEC sp_configure 'min server memory (MB)', 4096;  -- 4GB in MB
RECONFIGURE;