Stores information about the many-to-many relationship between instances and logical clusters. You need not have the mon_role role to query this monitor table. This monitoring table is available only for Adaptive Server Cluster Edition
You need not enable any configuration parameters for
this monitoring table to collect data.
Name |
Datatype |
Description |
|---|---|---|
LCID |
int |
Logical cluster ID |
LogicalClusterName |
varchar(30) |
Logical cluster name |
InstanceID |
tinyint |
ID of the instance within the cluster |
InstanceName |
varchar(30) |
Instance name |
Type |
varchar(20) |
Instance type |
FailoverGroup |
tinyint |
Failover group to which this instance is a member (failover instances only) |
State |
varchar(20) |
State of this instance with respect to the logical cluster |
ActiveConnections |
int |
Number of active connections for this logical cluster on this instance |
NonMigConnections |
int |
Number of active connections that do not support the connection migration protocol |
NonHAConnections |
int |
Number of active connections that do not support the high availability failover protocol |
LoadScore |
real |
Workload score for this instance using the load profile associated with its logical cluster |
