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).
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|
Any suggestion from Aireforge should be thoroughly tested before being implemented into production.