Can less RAM cause SSIS Package to run slower?

  • I am used to working on a machine with a 2.9 gig processor and 64 Gig of RAM. I am now working on a machine with a 2 Gig processor and only 4 Gig of RAM and a simple package for loading data from a flat file to a table in the database with no transformations seems to be very slow, Could RAM be the problem?

  • dndaughtery (11/18/2009)


    I am used to working on a machine with a 2.9 gig processor and 64 Gig of RAM. I am now working on a machine with a 2 Gig processor and only 4 Gig of RAM and a simple package for loading data from a flat file to a table in the database with no transformations seems to be very slow, Could RAM be the problem?

    I am not sure the issue is rams only but more like platform and rams because I am assuming your new box is x86 instead of x64 like the first one.

    Kind regards,
    Gift Peddie

  • Thats true. I now use a 32 bit machine and was using a 64 bit machine before.

  • dndaughtery (11/18/2009)


    Thats true. I now use a 32 bit machine and was using a 64 bit machine before.

    So yep it is a platform issue now you know why most production Oracle is x64 since 2001.

    😉

    Kind regards,
    Gift Peddie

Viewing 4 posts - 1 through 3 (of 3 total)

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