We help IT Professionals succeed at work.

How to release memory held by SSIS?

I have a SQL Server with 12G of memory.  Generally it uses about 1G of memory.  However after I ran an SSIS package (which is developed by me btw).  The memory usage goes up to 11G.  Even I close the package.  Now I can only fix this issue with a server reboot.  Is there a way to manually release the memory held by SSIS?  Thanks.
Comment
Watch Question

Database Analyst
CERTIFIED EXPERT
Commented:
You can't release memory SQL is using unless you restart SQL service - please read below:

SQL data(mainly) and code cache will take most of the physical RAM from that box unless you specify that in SQL MEM config: http://support.microsoft.com/kb/321363

"[...]  the Task Manager and Performance Monitor may show that the physical memory available on the computer is steadily decreasing until the available memory is between 4 to 10 MB."

Author

Commented:
Thanks.