Specific to cluster environments – 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 |
Attributes |
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:
|