(Cluster environments only) Displays information about the many-to-many relationship between instances and logical clusters.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monLogicalClusterInstance are:
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 |
