SQL Server uses too much RAM; memory usage increases out of control
Symptom
SQL Server memory usage grows until it consumes all of the RAM on the system, affecting the performance of other processes.
Environment
Any SQL Server host machine.
Fix/Answer
By default, SQL Server is configured for maximum performance, allowing it to use a maximum of roughly 2,000 terab...