July 26, 2012 at 10:52 am
I have read in some MS article that its not advisable to cluster SSIS.
My customer has a requirement to do so?
Can someone guide me about this.
July 26, 2012 at 12:05 pm
You can't cluster SSIS, but you can have it running separately on each node, which accomplishes much the same thing. All it really means is that, if the SSIS service fails on the active node, it won't automatically cause a failover to the passive node. "Cluster aware" services, like the SQL service, will cause it to automatically fail over.
More data on the differences here: http://technet.microsoft.com/en-us/library/cc737366(v=WS.10).aspx
I've admin'ed plenty of SQL clusters that ran SSIS. Works just fine.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 30, 2012 at 1:06 am
GSquared (7/26/2012)
You can't cluster SSIS, but you can have it running separately on each node, which accomplishes much the same thing. All it really means is that, if the SSIS service fails on the active node, it won't automatically cause a failover to the passive node. "Cluster aware" services, like the SQL service, will cause it to automatically fail over.More data on the differences here: http://technet.microsoft.com/en-us/library/cc737366(v=WS.10).aspx
I've admin'ed plenty of SQL clusters that ran SSIS. Works just fine.
Any idea if it works in SSIS 2012? SSIS is moved inside the DB engine, so I wonder if it's cluster aware...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 1, 2012 at 6:31 am
Koen Verbeeck (7/30/2012)
GSquared (7/26/2012)
You can't cluster SSIS, but you can have it running separately on each node, which accomplishes much the same thing. All it really means is that, if the SSIS service fails on the active node, it won't automatically cause a failover to the passive node. "Cluster aware" services, like the SQL service, will cause it to automatically fail over.More data on the differences here: http://technet.microsoft.com/en-us/library/cc737366(v=WS.10).aspx
I've admin'ed plenty of SQL clusters that ran SSIS. Works just fine.
Any idea if it works in SSIS 2012? SSIS is moved inside the DB engine, so I wonder if it's cluster aware...
Microsoft recommends against clustering SSIS. http://support.microsoft.com/kb/942176
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 1, 2012 at 6:42 am
GSquared (8/1/2012)
Koen Verbeeck (7/30/2012)
GSquared (7/26/2012)
You can't cluster SSIS, but you can have it running separately on each node, which accomplishes much the same thing. All it really means is that, if the SSIS service fails on the active node, it won't automatically cause a failover to the passive node. "Cluster aware" services, like the SQL service, will cause it to automatically fail over.More data on the differences here: http://technet.microsoft.com/en-us/library/cc737366(v=WS.10).aspx
I've admin'ed plenty of SQL clusters that ran SSIS. Works just fine.
Any idea if it works in SSIS 2012? SSIS is moved inside the DB engine, so I wonder if it's cluster aware...
Microsoft recommends against clustering SSIS. http://support.microsoft.com/kb/942176
This KB is about SSIS 2005/08. In SQL 2012, SSIS is inside the DB engine so I wonder if the clustering behaviour has changed.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 6, 2012 at 7:25 am
SSIS can be clustered, but you have to do it manually.
However, there are very few situations where clustering SSIS will be of benefit, and many situations where it can be cause problems.
If you are going to run only a single SQL cluster on your Windows cluster and you want to use msdb as your SSIS package store, then you can cluster SSIS. The SSIS service shold be defined within the SQL DB Engine cluster group, so everything fails over as a whole. The main advantage you gain from clustering SSIS is if you use msdb as the SSIS package store then you have a single place for where you must deploy updates.
If you are going to run more than one SQL cluster on your Windows cluster, or if you are going to run a mixture of clustered and non-clustered SQL instances on your Windows cluster, or if you use local disk as your SSIS package store, then you should NOT cluster SSIS. If you did cluster SSIS in this situation, you would find that only SQL instances that are active on the node that has the active SSIS instance would be able to connect to it. When you fail SSIS to another node, any SQL instances left behind on the original node would not be able to connect to SSIS. Additionally, if you have not deployed package updates to all package stores, then what gets run would depend on which node SSIS happens to be running on.
If you do decide that clustering SSIS could be helpful, then FineBuild can set this up for you.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply