Maximum Memory Too Low

This warning has been raised because SQL Server is configured with a maximum memory setting that could potentially be raised. The SQL Server edition being run supports a higher memory setting, and the amount of physical memory on the server is high enough to raise the limit for SQL Server without impacting the OS.

⚠ This recommendation is based on the assumption that the server is being used purely for SQL Server and is not also running any other memory intensive services.

Suggested Action

💡 Aireforge Advisor can automatically generate a script for this.

Consider increasing the amount of memory that SQL Server can address.

How To Set the Maximum Server Memory in SQL Server

EXEC sys.sp_configure N'show advanced options', N'1'
RECONFIGURE
GO
EXEC sys.sp_configure N'max server memory (MB)', N'14000'
GO
RECONFIGURE
GO

Further Reading

Server memory configuration options | Microsoft Docs