Home Forums SQL Server 2008 SQL Server 2008 Administration Adding Integration Services to clustered nodes RE: Adding Integration Services to clustered nodes

  • October 31, 2011 at 10:43 am

    #1401209

    SQLArcher (10/28/2011)

    The article doesn't state that it is not recommended on a cluster, the article states that it is not recommended to configure SSIS as cluster resource.

    To install SSIS on a cluster is perfectly fine as the SSIS engines will run independently of one another on each node.

    Not quite what I said/meant as I know this

    MysteryJimbo (10/28/2011)

    I don't install SSIS on clusters as its not recommended and isnt cluster aware. Have you read this article?

    http://msdn.microsoft.com/en-us/library/ms345193.aspx

    Clustering Integration Services is not recommended because the Integration Services service is not a clustered or cluster-aware service

    Why have it on a cluster if you cannot cluster the service unless its licence cost implications? Its an extra memory hog which is most likely better off running on another server. You'll also experience fewer issues.