Change SQL max memory

Log on the SQL Server and start a new Query

– Set the SQL Server in Operation Mode –

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
go

– View Settings that are running on the server –

EXEC sp_configure;

– Set Max Memory (MB) – (in this example the max is set to 6 GB)

EXEC  sp_configure'max server memory (MB)',6000;

Activate the Settings

RECONFIGURE;
GO

Leave a Reply