(Cluster environments only) Displays currently configured workload profiles. 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 monWorkloadProfile are:
Name |
Datatype |
Description |
---|---|---|
ProfileID |
smallint |
Workload profile ID |
ConnectionsWeight |
tinyint |
Weight associated with the |
CpuWeight |
tinyint |
Weight associated with the |
RunQueueWeight |
tinyint |
Weight associated with the |
IoLoadWeight |
tinyint |
Weight associated with the |
EngineWeight |
tinyint |
Weight associated with the |
UserWeight |
tinyint |
Weight associated with the |
LoginThreshold |
Threshold for the login load distribution. |
|
DynamicThreshold |
smallint |
Threshold for dynamic load distribution (that is, post-login migration for load purposes) |
Hysteresis |
tinyint |
Minimum load score that enables redirection. |
Name |
varchar(30) |
Workload profile name |
Type |
varchar(30) |
Type of workload profile. Indicates whether the profile is defined by a user or the system. Values are:
|