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.
💡 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
Server memory configuration options | Microsoft Docs