(Cluster environments only) Tracks the time at which the cluster membership service (CMS) detects the failure, gets a new cluster view, resynchronizes the heartbeat, posts the failure event, and completes the failure event. There is a row for each instance.
You need not enable any configuration parameters for this monitoring table to collect data.
monCMSFailover contains these columns:
Column name |
Type |
Description |
|---|---|---|
InstanceID |
tinyint1 |
Instance performing the failover. |
FailedInstanceID |
varchar(96) |
List of failed instance IDs, separated by commas. |
FailDetectTime |
datatime(8) |
Time when cluster failure is detected. |
InitViewTime |
datatime(8) |
Time when initial cluster view is obtained. |
FinalViewTime |
datatime(8) |
Time when final cluster view is obtained. |
ResynchHBTime |
datatime(8) |
Time when cluster-wide heartbeat is resynchronized. |
NotifyFailTime |
datatime(8) |
Time when failure event is posted. |
EventdoneTime |
datatime(8) |
Time when last failure event is finished. |
