Post reply

SSIS on a dedicated server?

  • March 29, 2016 at 3:27 pm

    #1868423

    sqlfriends (3/29/2016)

    I will put CPU thing on another research.

    But for implementing and upgrading to new environment, just want to know to put ssis on a separate server or on the ETL destination server.

    We only have nightly jobs that runs.

    And the destination is all in the data warehouse databases tables.

    If SSIS has its own server:

    I know SQL 2014 has SSIScatalog database, and I read from previous post, it has to be on the same server of SSIS service, that means we do need to install database engine on the same server of SSIS, even it only hosts SSIScatlog database.

    This again will also compete resources with SSIS.

    The second is if on same server at least either source or destination will on the same server, if put on its own server, both destination and source will not be local, that I found slow for it is cross network.

    Currently we put on the same server, and the RAM is already 94GB.

    Thanks,

    You have not asked any additional questions. Is this a blog post?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • March 29, 2016 at 3:30 pm

    #1868424

    It depends on a number of issues. CPU, memory, Network bandwidth, etc.

    Ideally it performs better on a separate server than the database server.

    If you are doing simple bulk inserters how do you tune that?

    typo: how

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

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

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