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.
💡 Select 'Suggested Script' for an automatically generated script.
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