SQL Server Performance

Cluster sql server per service

Discussion in 'Getting Started' started by soorena, Oct 23, 2009.

  1. soorena New Member

    I have 2 node Cluster sql 2005 on server 2003 and SAN and work very good for hardware failure.I wanna sometimes each service of sql goes down second node come active,I wan`t failover per service no hardware
  2. satya Moderator

    Welcome to the forums.
    All the resources in cluster needs to be active when a failover happens.
    YOu need a better understanding of cluster and see what is referred in BOL:
    When working with SQL Server 2005 failover clustering, remember that the server cluster consists of a failover cluster instance that runs under Microsoft Cluster Services (MSCS). The SQL Server instance may be hosted by Microsoft MSCS-based nodes that provide the Microsoft Server Cluster.
    If problems exist on the nodes that host the server cluster, those problems may manifest themselves as issues with your failover cluster instance. To investigate and resolve these issues, troubleshoot a SQL Server failover cluster in the following order:
    1. Hardware: Review Microsoft Windows system event logs.

Share This Page