Microsoft SQL Server Set max server memory size


Example

USE master
EXEC sp_configure 'max server memory (MB)', 64
RECONFIGURE WITH OVERRIDE