#sp_configure

Set the Minimum and Maximum Memory in SQL Server

SQL Server will dynamically adjust how much memory it uses while assuming it can use a much memory as it can find on your database server. You can configure minimum and maximum amounts allowed with some simple settings, which can prevent SQL Server from consuming too much memory and causing other issues. The easiest way to set the minimum and maximum values is to use the SQL Server Management…

Importance of Memory Setting in SQL Server

Memory is one among the resources forming the performance triangle—CPU and storage being the other two. If one is hit, the other two take the load to try to bring the performance to acceptable levels, but there’s always the trade-off. Whatever transactions cannot be committed to the memory they would be forwarded to the disk subsystem by SQL Server. This causes a performance bottleneck.…