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.
This monitoring table is available only for Adaptive Server Cluster Edition.
You need not enable any configuration parameters for
this monitoring table to collect data.
Name |
Datatype |
Description |
|---|---|---|
InstanceID |
tinyint |
ID of the instance within the cluster |
InstanceName |
varchar(30) |
Instance name |
LoadProfileID |
smallint |
Load profile ID |
LoadProfile |
varchar(30) |
Name of load profile used to generate the load score |
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 |
