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

    HI,
    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?
    Thanks,
    Gopal
    GopalMynam, Jan 7, 2009
    #2

  2. ndinakar Member

    It should not take 40-60 seconds. It should be more like 5 seconds. Yes clients need to reconnect.
    ndinakar, Jan 7, 2009
    #3

  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.
    satya, Jan 8, 2009
    #4

  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?
    Thanks,
    Gopal
    GopalMynam, Jan 9, 2009
    #5

  5. gurucb New Member

    gurucb, Jan 9, 2009
    #6

  6. satya Moderator

    satya, Jan 11, 2009
    #7

Share This Page