Is SQL Server Memory Settings Affecting Your Server’s Performance?
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.
June 10, 2013
