monWorkload

Description

(Cluster environments only) Displays the workload score for each logical cluster on each instance according to its load profile.

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

Columns

The columns for monWorkload are:

Name

Datatype

Description

LCID

tinyint

Logical cluster ID

InstanceID

tinyint

ID of the instance within the cluster

LoadProfileID

tinyint

ID 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

LogicalClusterName

varchar(30)

Logical cluster name

InstanceName

varchar(30)

Instance name

LoadProfileName

tinyint

Name of the load profile used to generate the load score