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.
-
How to adjust memory usage by using configuration options in SQL Serverypercubeᵀᴹ– ypercubeᵀᴹ2012年06月06日 07:58:01 +00:00Commented Jun 6, 2012 at 7:58
-
Is it a problem that SQL-Server is using a lot of memory?ypercubeᵀᴹ– ypercubeᵀᴹ2012年06月06日 08:28:14 +00:00Commented Jun 6, 2012 at 8:28
-
I use SSIS to convert data from OldDatabase to NewDatabase, when package1 execute, system memory usage become full and execute of package2 become very slow. but if I restart SQL Server service and realease sql server memory usage and then execute package2, this package run very fast.mehdi lotfi– mehdi lotfi2012年06月06日 08:32:26 +00:00Commented Jun 6, 2012 at 8:32
-
Please see this question: dba.stackexchange.com/questions/6691/…jrara– jrara2012年06月06日 09:51:02 +00:00Commented Jun 6, 2012 at 9:51
-
I did set the "max sever memory" option, but somehow it doesn't work. Any suggestions?user9487– user94872012年06月19日 09:39:19 +00:00Commented Jun 19, 2012 at 9:39
2 Answers 2
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.
-
I would always suggest to set a max memory, otherwise you can run in memory problems even on dedicated machines.Ionic– Ionic2015年06月17日 08:37:10 +00:00Commented Jun 17, 2015 at 8:37
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.
Explore related questions
See similar questions with these tags.