monWorkloadProfile

Description

(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.

Columns

The columns for monWorkloadProfile are:

Name

Datatype

Description

ProfileID

smallint

Workload profile ID

ConnectionsWeight

tinyint

Weight associated with the active connections metric

CpuWeight

tinyint

Weight associated with the cpu utilization metric

RunQueueWeight

tinyint

Weight associated with the run queue metric

IoLoadWeight

tinyint

Weight associated with the io load metric

EngineWeight

tinyint

Weight associated with the engine deficit metric

UserWeight

tinyint

Weight associated with the user metric metric

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:

  • User

  • System