SQL Server Performance

Monitoring Cluster errors

Discussion in 'SQL Server Clustering' started by Hover, Apr 12, 2006.

  1. Hover New Member

    Hi,
    What are the performance counters and errors which can be monitored to know whether a node is working perfectly in clustered envoirment.
    For both Active/Active and Active/Passive Cluster


  2. satya Moderator

  3. Hover New Member

    Is there is any counter especially dedicated to cluster
  4. Hover New Member

    Hw Will I know that one node is down and other node has taken the resources perfectly to work.Which errors should I observe for this.
  5. satya Moderator

    I don't see there are any specific counters in the cluster, as per the SQL is concerned it is an usual installation. Follow the links above for the counters to monitor.

    Event viewer, SQL Server error log is the best bet to look for any warnings or issues.
    http://www.sql-server-performance.com/real_life_dba_cluster_failover.asp

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page