SQLServerCentral.com / SQL Server 2005 / SQL Server 2005 Integration Services / Memory / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 03 Mar 2015 14:01:26 GMT20RE: Memoryhttp://www.sqlservercentral.com/Forums/Topic521387-148-1.aspxFirst, how did you end up with 12.5gb of memory in a server? 3 4gb dims and a .5gb dim? It is a strange number.Are you running 32bit or 64bit SQL Server?What is actually using the memory? Is there a dtexec process hanging, or has SQL Server simply cached a lot of data?Mon, 23 Jun 2008 05:31:01 GMTMichael Earl-395764RE: Memoryhttp://www.sqlservercentral.com/Forums/Topic521387-148-1.aspxDo you have Huge tables? Do you use lookups to join those tables.?Is your server 32-BIt and which SQL Server Edition do you have? ENT/STD/.Sun, 22 Jun 2008 17:01:14 GMTMannySinghRE: Memoryhttp://www.sqlservercentral.com/Forums/Topic521387-148-1.aspxWhich service pack are you on right now.What Does the SSIS PAckage do?Sun, 22 Jun 2008 16:52:30 GMTMannySinghRE: Memoryhttp://www.sqlservercentral.com/Forums/Topic521387-148-1.aspxhi,do you use scripts ? what other components do you use ?is it One package or all of your packages ? what version do you have ? (with SP ) Yaron , Sun, 22 Jun 2008 08:29:47 GMTyaronMemoryhttp://www.sqlservercentral.com/Forums/Topic521387-148-1.aspxHi Everyone,I am facing a memory problem on my development server.I have 12.5 GB RAM available. During any SSIS run the memory drops to less than 1 GB and never recovers after the run is completed. I am overcoming this by restarting the sql service or restating the server machine; which will free the memory unto 11 GB. Sadly, after any other SSIS run the memory drops again to 1GB. Kindly advice how to overcome this headache.ThxSun, 22 Jun 2008 01:56:13 GMTdemitri_baran