Monitoring SQL Cluster | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Monitoring SQL Cluster

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.
Rahul.

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.
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.
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?
Do u have any monitoring tools installed on the server other than Perfmon? For example, BMC or Tivoli?
Few articles for your reference on monitoring cluster:
http://www.sql-server-performance.com/clustering_2000.asp
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part4/c1261.mspx HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>