Maximum Memory Too High

This warning has been raised because SQL Server's maximum memory setting is set higher than the physical memory on the server (or greater than the maximum recommended memory).

Suggested Action

šŸ’” Aireforge Advisor can automatically generate a script for this.

Lower the maximum memory to allow for SQL Server and the operating system; up to a maximum of 90% of the total physical RAM.

Physical Memory Reserve for OS
< 4GB 50% of available memory
4GB > 8GB 1GB
8GB > 12GB 2GB
12GB > 16GB 3GB
>16GB 4GB