Saturday, December 2, 2017

SQL Server - SSIS Configuration for Fault Tolerance

Integration Services service is not a clustered or cluster-aware service and does not support failover from one cluster node to another. Therefore, in a clustered environment, Integration Services should be installed and started as a stand-alone service on each node in the cluster.


                                     Fig. showing SSIS Configuration for Fault Tolerance 

There will be only & only manual failover between the SSIS instances once SQL Agent send Job failure email notification to respective team
SSIS Manual Failover Cases:
Case 1- SQL Server A is down
oIt will switch to SQL Server B because of AlwaysOn
oSSIS B instance will refresh the SQL Server B.
Case 2- SSIS A instance is down
oSSIS B instance will run all the packages to refresh the database in Server B
o Server A & Server B databases will be in sync because of AlwaysOn
Case 3- SQL Server B is down
oIt will switch to SQL Server A
oSSIS A instance will refresh the SQL Server A.
Case 4- SSIS B instance is down
oSSIS A instance will run all the packages to refresh the database in Server A
oServer A & Server B databases are in sync because of AlwaysOn


Restarting of the packages
oIf SSIS instance goes down during package execution
SQL Server Agent job will fail and send the Job failure email notification to the respective team
Manual failover will be performed to switch to another SSIS instance 
Process will be start from starting Point.
ETL & SQL Error & transactional handling will be used to start the process from starting point
oIf the package failed during execution then
Package will be restarted from the point of failure by using Checkpoint capabilities of the SSIS.
ETL & SQL Error & transactional handling will be used for starting the process from point of failure.
Load Balancing
oPackage Level load balancing can be performed by using SSIS -Balanced Data Distributor/ performing parallel processing in the package.
oSSIS Instance level load balancing is not recommended because SSIS supports manual failover only  for which if a server is down another server should be available for complete data processing.


2 comments:

  1. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. machine learning projects for final year In case you will succeed, you have to begin building machine learning projects in the near future.

    Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.


    Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.

    ReplyDelete
  2. Awesome post. Typically the put up can affect a considerable amount of instant concerns our the community. We tend to can't be uninvolved towards such concerns. This unique put up will provide good ideas not to mention strategies. Especially instructive not to mention efficient. Fault Location Services Dahlgren

    ReplyDelete