SSIS Memory Allocation - 64 bit
-
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.
-
Hi Andy - refer to http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspx
Tommy
Follow @sqlscribe -
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.
-
NP
Tommy
Follow @sqlscribe -
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,
-
Take a look at the topic "Influencing buffer sizing" in the article mentioned above.
Tommy
Follow @sqlscribe -
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 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply