USE master
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
-- enable lookup of memory usage
USE master
EXEC sp_configure 'max server memory (MB)'
-- check current max memory usage in mb
USE master
EXEC sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
-- disable lookup of memory usage

