Post reply

SSIS Memory Allocation - 64 bit

  • October 29, 2007 at 12:42 pm

    #180709

    I am trying to understand if SSIS can be configured to use more memory on a 64 bit machine? I have a machine that has 10 gig RAM and I notice that anytime my package is running (via DTExec.exe), the process (DTExec.exe) never uses more than 100 mb. I noticed that SQL Server (2005) has around 9.2 gig being used (viewing memory usage in task manager).

    Does SSIS take only what it needs? How best can I configure both SQL Server 2005 and SSIS on the same machine so that both are effectively making use of my 10 gig RAM?

    Regards,

    Andy T.

  • October 30, 2007 at 9:17 am

    #746688

    Hi Andy - refer to http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspx

    Tommy

    Follow @sqlscribe

  • October 31, 2007 at 11:53 am

    #747197

    Thanks Tommy!

    In addition to making some of the changes mentioned in this article, I am also going to test setting the MAX memory that SQL Server uses to something like 6 Gb. I don't like that it is using 9.2 Gb. I figure the OS and SSIS would run *better* if there is more memory available.

    Thanks again!

    - Andy T.

  • October 31, 2007 at 12:01 pm

    #747200

    NP 🙂

    Tommy

    Follow @sqlscribe

  • December 19, 2007 at 7:46 am

    #761402

    Hello,

    I have a little problem. My DTSX packages uses at max 256mb of memory.

    Do you know how to set it to 2gb ?

    Best Regards,

  • December 19, 2007 at 7:56 am

    #761406

    Take a look at the topic "Influencing buffer sizing" in the article mentioned above.

    Tommy

    Follow @sqlscribe

  • December 19, 2007 at 8:43 am

    #761429

    Thanks Tommy,

    I set most of the buffer size options.

    I'll try for the first time with the /3GB or /AWE switch on the Windows Server boot.ini

    I'll post the result when i'm done with it.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply