5

How can release memory usage of sql server by command. my system have 16GB RAM, but when get huge query by sql server, memory usage become full. if I restart SQL Server service memory usage become free. but I want to release memory usage of sql server after each huge query execute.

5

2 Answers 2

10

SQL Server is supposed to use all the memory. If you want to reserve memory for other things set the max server memory setting in SQL Server so that it'll stop eating up all the memory.

1
  • I would always suggest to set a max memory, otherwise you can run in memory problems even on dedicated machines.
    – Ionic
    Jun 17, 2015 at 8:37
0

SQL Server will always use as much as memory as he can gets. Even on a server which is designed just for SQL Server, you should define a max memory usage on the instance. Otherwise your windows can run in a memory pressure if you try to connect to the machine as admin.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.