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

💡 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

Further Reading

Server memory configuration options | Microsoft Docs