SQL Server Performance

Monitoring SQL Cluster

Discussion in 'SQL Server Clustering' started by rahulpict, Aug 2, 2004.

  1. rahulpict New Member

    I am having following queries reagarding SQL Cluster Monitoring,

    1. Does clustering ever use a mirroring of data (2copies of the data synchronized between sites)? Or is it always only shared data (1 copy) between virtual DB#%92s?

    2. Can we monitor a replication "heartbeat"?

    Any information on the above would be appreciated.

    Thanks in advance.
  2. Argyle New Member

    About 1.
    Clustering itself does not use mirroring. It's a failover cluster. So an SQL instance and its disks can only be active on a single server node at a time.

    You can set up mirroring with for example merge replication but it would be no difference setting up this between two virtual sql servers in a cluster than two standard sql servers not in a cluster.
  3. Vinny New Member

    Regarding 2: Are u saying monitoring "cluster heartbeat?" If you have thrid party tools to monitor Network cards, then one can use those tools to minitor it. I am assuming that heartbeat you are refeering is for cluster.
  4. rahulpict New Member

    Thanks for your reply.

    What information should we gather in order to monitor clustered SQL Server?
    And while Monitoring how we can differtiate between SQL cluster and stand alone sql server machine?
  5. Vinny New Member

    Do u have any monitoring tools installed on the server other than Perfmon? For example, BMC or Tivoli?
  6. satya Moderator

Share This Page