Post reply

Distributed Deployment Good or Bad?

  • December 13, 2009 at 11:09 pm

    #156499

    In the many pounds of books I've been reading on SSIS lately, it seems most experts are recommending to install SSIS on a box separate from the SQL Service box. I understand how this configuration might be more scalable, BUT now, any data your package moves around has to be pulled over into the SSIS pipeline from the database server to the SSIS server. That seems pretty costly to me!

    .

  • December 14, 2009 at 6:43 am

    #1091906

    BrainMan (12/13/2009)

    In the many pounds of books I've been reading on SSIS lately, it seems most experts are recommending to install SSIS on a box separate from the SQL Service box. I understand how this configuration might be more scalable, BUT now, any data your package moves around has to be pulled over into the SSIS pipeline from the database server to the SSIS server. That seems pretty costly to me!

    The recommendation is made because SSIS is quite CPU and memory intensive. Do you have some particular scenario in mind that you are concerned?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • December 14, 2009 at 9:01 am

    #1092012

    My scenario is that I have developed a few SSIS 2008 packages not realizing that they would not run on my production SQL 2005 Server. So, my plan is to install SQL 2k8 on another server, and use that as the SSIS box. I'm concerned about what kind of performance degradation I might run into NOT having the SSIS process running on the same box as the DB server.

    Hopefully, I'm worried about nothing.

    Thanks

    .

  • December 14, 2009 at 9:04 am

    #1092017

    BrainMan (12/14/2009)

    My scenario is that I have developed a few SSIS 2008 packages not realizing that they would not run on my production SQL 2005 Server. So, my plan is to install SQL 2k8 on another server, and use that as the SSIS box. I'm concerned about what kind of performance degradation I might run into NOT having the SSIS process running on the same box as the DB server.

    Hopefully, I'm worried about nothing.

    Thanks

    You have to make sure you are not transferring huge amounts of data back/fore. Otherwise I don't think you will have too much performance issues.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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