(Cluster environments only) Provides an estimate of how a load profile impacts the workload score without enabling the profile. monWorkload includes one row for each logical cluster and instance on which this logical cluster is running. The load score and components are based on the current profile for that logical cluster. The monWorkloadPreview table has one row for each combination of instance and load profile configured on the system, allowing the administrator to see how workload scoring would be done for each profile. You need not have the mon_role role to query this monitor table.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monWorkloadPreview are:
Name |
Datatype |
Description |
---|---|---|
InstanceID |
tinyint |
ID of the instance within the cluster |
LoadProfileID |
smallint |
Load profile ID |
LoadScore |
int |
Load score for this instance or logical cluster |
ConnectionScore |
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 |
InstanceName |
varchar(30) |
Instance name |
LoadProfileName |
varchar(30) |
Name of load profile used to generate the load score |