Configure the Minimum and Maximum memory for SQL Server Instance


The T-SQL script for configuring the minimum and maximum memory for SQL Server database instance is below:


sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
--Specify minimum memory in MB

sp_configure 'min server memory', 2048;
GO
RECONFIGURE;
GO
 --Specify minimum memory in MB
sp_configure 'max server memory', 4096;
GO
RECONFIGURE;
GO

To understand the minimum and maximum memory concept in SQL Server, refer to the article - https://www.sqlshack.com/min-and-max-memory-configurations-in-sql-server-database-instances/

7 views0 comments