(Cluster environments only) Displays the workload score for each logical cluster on each instance according to its load profile.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monWorkload are:
Name |
Datatype |
Description |
---|---|---|
LCID |
tinyint |
Logical cluster ID |
InstanceID |
tinyint |
ID of the instance within the cluster |
LoadProfileID |
tinyint |
ID of the load profile used to generate the load score |
LoadScore |
int |
Load score for this instance or logical cluster |
ConnectionsScore |
float |
Weighted value for the |
CpuScore |
float |
Weighted value for the |
RunQueueScore |
float |
Weighted value for the |
IoLoadScore |
float |
Weighted value for the |
EngineScore |
float |
Weighted value for the |
UserScore |
float |
Weighted value for the |
LogicalClusterName |
varchar(30) |
Logical cluster name |
InstanceName |
varchar(30) |
Instance name |
LoadProfileName |
tinyint |
Name of the load profile used to generate the load score |