Specific to cluster environments – 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 |
Attributes |
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 |