I've heard MS SQL Server takes up as much RAM as it can to cache results. Well, it's not leaving enough bargaining room for our little server's RAM.
How do I change the settings to limit the amount of RAM it can use?
MS SQL Server running on Windows Server 2008.
Best Answer
From How to configure memory options using SQL Server Management Studio:
You can also do it in T-SQL using the following commands (example):