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 |