Set max server memory in SQL Server Instance

--show advanced options
EXEC sys.sp_configure N'show advanced options', N'1'  
RECONFIGURE WITH OVERRIDE
GO
--set max server memory
EXEC sys.sp_configure N'max server memory (MB)', N'15360'
GO
RECONFIGURE WITH OVERRIDE
GO
--disable advanced options
EXEC sys.sp_configure N'show advanced options', N'0'  
RECONFIGURE WITH OVERRIDE
GO

This site uses Akismet to reduce spam. Learn how your comment data is processed.