SQL Server 2008 R2 Integration Services Failover Clustering

I’m reading through the MSDN information about clustering the SQL Server 2008 R2 SSIS service and (uh!) found a slight inconsistency…

The source: http://technet.microsoft.com/en-us/library/ms345193(v=sql.105).aspx

The follow paragraph is what makes a little puzzled, especially the part in bold:

“When you have multiple SQL Server resource groups that include the Integration Services service in a cluster, a failover could lead to unexpected results. Consider the following scenario. Group1, which includes the SQL Server service and the Integration Services service, is running on Node A. Group2, which also includes the SQL Server service and the Integration Services service, is running on Node B. Group 2 fails over to Node A. The attempt to start another instance of the Integration Services service on Node A fails because the Integration Services service is a single-instance service. Whether the SQL Server service that is trying to fail over to Node A also fails depends on the configuration of the Integration Services service in Group 2. If the Integration Services service was configured to affect the other services in the resource group, the SQL Server service that is failing over will fail because the Integration Services service failed. If the service was configured not to affect the other services in the resource group, the SQL Server service will be able to fail over to Node A. Unless the Integration Services service in Group 2 was configured not to affect the other services in the resource group, the failure of the Integration Services service that is failing over could cause the SQL Server service that is failing over to fail also.

How am I supposed to know if the SQL Server service will fail or not when having SQL Server and SSIS in the same resource group (when I have configured that SSIS shouldn’t affect other services)?

Does clustering the SSIS result in anything other than an epic fail according to Microsoft?! Which one of the two overview schematics apply to the real world???

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: