SQL Server Performance

Two node multi instance cluster (Active-Active)

Discussion in 'SQL Server 2005 Clustering' started by GopalMynam, Jan 7, 2009.

  1. GopalMynam New Member

    I just completed the installation of a active-active cluster. one SQL instance in each node.
    I did manual failover and every thing works correctly.
    The manual failover takes about 40 to 60 sec.
    I also noticed that the connection breaks to the SQL virtual instance in management studio.
    Is it right behaviour? Does client application needs to reconnect when ever SQL instance failover takes place?
  2. ndinakar Member

    It should not take 40-60 seconds. It should be more like 5 seconds. Yes clients need to reconnect.
  3. satya Moderator

    If the failover is taking such time then it is better to identify which group is taking time to come online when you are performing the failover between the nodes. In general the disks will take such longer time to come-online, so better to keep an eye on Event VIewer.
  4. GopalMynam New Member

    Thanks Dinakar and Satya for your quick reply.
    I have one more question, I did not install integration services in any of the instances in cluster. I think integration services is not cluster aware. If I need to use SSIS packages, what is the best way to achieve?
  5. gurucb New Member

  6. satya Moderator

Share This Page