Post reply

Query on SSIS load

  • June 22, 2015 at 11:30 am

    #297999

    Hi Team, I need some feedback/pointers on SSIS architecture.

    Our current prod setup has a dedicated SSIS server.Now we have been told that this server would be used to host more application's SSIS (no is not known, say 35 more packages).

    My question: will this have an impact on our SSIS performance. I ask this as our SSIS packages have dedicated servers and they are used only to store and run the packages and all other operations like DB, file servers are on different servers.

    What factors should be considered before we are moving more packages on the same server. I assume memory usage and other resources would be few of those?.

    Regards.

    GCIT

  • June 22, 2015 at 11:43 am

    #1807127

    Keep in mind that when using data flows in SSIS, the data has to go from the source server to the SSIS server and then to the destination server. This mean that you also have to consider the network traffic,along with the memory and CPU usage.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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