Applies to 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 user connections metric |
CpuScore |
float |
Weighted value for the cpu utilization metric |
RunQueueScore |
float |
Weighted value for the run queue metric |
IoLoadScore |
float |
Weighted value for the io load metric |
EngineScore |
float |
Weighted value for the engine deficit metric |
UserScore |
float |
Weighted value for the user metric |
LogicalClusterName |
varchar(30) |
Logical cluster name |
InstanceName |
varchar(30) |
Instance name |
LoadProfileName |
tinyint |
Name of the load profile used to generate the load score |