Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
    
thank you very much. –  mehdi lotfi Jun 6 '12 at 8:26
    
Is it a problem that SQL-Server is using a lot of memory? –  ypercube Jun 6 '12 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 Jun 6 '12 at 8:32
    
Please see this question: dba.stackexchange.com/questions/6691/… –  jrara Jun 6 '12 at 9:51

1 Answer 1

up vote 9 down vote accepted

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.

share|improve this answer
    
thank you very much. –  mehdi lotfi Jun 6 '12 at 10:42

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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