monWorkload

Description

Displays the workload score for each logical cluster on each instance according to its load profile. This monitoring table is available only for Adaptive Server Cluster Edition.

NoteYou need not enable any configuration parameters for this monitoring table to collect data.

Columns

Name

Datatype

Description

InstanceID

tinyint

ID of the instance within the cluster

InstanceName

varchar(30)

Instance name

LCID

tinyint

Logical cluster ID

LogicalClusterName

varchar(30)

Logical cluster name

LoadProfile

varchar(30)

Name of the load profile used to generate the load score

LoadScore

int

Load score for this instance or logical cluster

ConnectionsScore

float

Weighted value for the user connections metric

CpuScore

float

Weighted value for the cpu utilization metric

RunQueueScore

float

Weighted value for the run queue metric

IoLoadScore

float

Weighted value for the io load metric

EngineScore

float

Weighted value for the engine deficit metric

UserScore

float

Weighted value for the user metric

LoginRedirections

int

Number of load-based login redirections this logical cluster performs on this instance

DynamicMigratoins

int

Number of load-based connection migrations (dynamic load distribution) this logical cluster performs on this instance