Applies to cluster environments only. Shows all administrative actions against logical clusters from start-up until these actions are released.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monLogicalClusterAction are:
Name |
Datatype |
Description |
---|---|---|
Handle |
int |
Unique handle used to cancel this action. |
State |
varchar(20) |
State of the action: active, complete, releasing, or canceled. |
LCID |
int |
Logical cluster ID to which this action applies. |
LogicalClusterName |
varchar(30) |
Logical cluster name of this logical cluster (denormalized to reduce joins). |
Action |
varchar(15) |
Action being performed. A combination of the command running and its scope. For example, offline instance or failover cluster. |
FromInstances |
varchar(96) |
A comma-separated list of from instances for this command and action (instance being brought offline). |
ToInstances |
varchar(96) |
A comma-separated list of to instances for this command and action (instances being brought online). |
InstancesWaiting |
int |
Number of instances waiting to go offline (this is a count of FromInstances that are in the time_wait state). |
WaitType |
varchar(20) |
Current wait state for this action. One of: wait, until, or nowait. |
StartTime |
datetime |
Date and time the command was issued. |
Deadline |
datetime |
Date and time the command must be finished (based on the time value supplied to the wait or until options). |
CompleteTime |
datetime |
Date and time the command and action completed (when InstancesWaiting is zero and the action went from active to the complete state). Returns NULL for incomplete actions. |
ConnectionsRemaining |
int |
Number of connections remaining to move as a result of this command. |
NonMigConnections |
int |
Number of connections to be terminated because they do not support the migration protocol. |
NonHAConnections |
int |
Number of connections that do not support the high availability failover protocol. These connections are disconnected and cannot fail over when the command finishes. |