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

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

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.