By: Barry Crowell, Senior Business Consultant KTL Solutions
By default, SQL Server’s max memory is 2147483647. With this default setting, SQL Server will “commit” as much memory as possible until there’s none left for the operating system to run efficiently.
If the operating system has no memory available, it will start using the page file instead of RAM. Using the page file in place of memory will result in poor system performance.
SQL Server really does need as much memory as possible. However, that doesn’t mean you should leave SQL Server’s max memory set to “unlimited.” If you starve the OS for memory, then Windows itself may not get the memory it needs.