November 14, 2011 at 12:30 pm
WHen running an SSIS package as a scheduled job on a sql server that is using a file based package, when the package runs, does it run in the memory context of sql server or SSIS. And if it is running within SSIS, do I need to deallocate memory for sql server. I have a 64 bit 2008 server with 32 gig of RAM on Win 2008. I had only allocated by mistake 16 gig to sql server. Changed it over the weekend to 28 gig and now some of the SSIS packages are taking much longer processing the same amount of data
November 14, 2011 at 12:44 pm
Have a look at the following: http://sqlblog.com/blogs/kevin_kline/archive/2008/10/09/ssis-packages-need-love-too-er-memory-too.aspx
I think the resources listed there will provide the necessary information.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply