monWorkloadProfile

Description

Displays currently configured workload profiles. 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.

Columns

Name	Datatype	Description
ProfileID	smallint	Workload profile ID
Name	varchar(30)	Workload profile name
RefreshInterval	varchar(15)	Frequency of load refresh, can be a time in the form hh:mm:ss or `DISABLED` or `AUTO`
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
LoginWeight	smallint	Threshold for load-based login redirection
Dynamicthreshold	smallint	Threshold for dynamic load distribution (that is, post-login migration for load purposes)
Type		System or user profile.
LoginThreshold		Threshold for the login load distribution.
Hysteresis		Minimum load score that enables redirection.