monWorkloadPreview

Description

Provides an estimate of how a load profile impacts the workload score without enabling the profile. monWorkloadpreview includes one row for each logical cluster and instance on which this logical cluster is running. The load score and components are based on the current profile for that logical cluster. The monWorkloadPreview table has one row for each combination of instance and load profile configured on the system, allowing the administrator to see how workload scoring would be done for each profile.

Columns

Name	Datatype	Description
InstanceID	tinyint1	ID of the instance within the cluster
LoadProfileID	tinyint1	Load profile ID
LoadScore	real4	Load score for this instance or logical cluster
ConnectionScore	real4	Weighted value for the `user connections` metric
CpuScore	real4	Weighted value for the `cpu utilization` metric
RunQueueScore	real4	Weighted value for the `run queue` metric
IoLoadScore	real4	Weighted value for the `io load` metric
EngineScore	real4	Weighted value for the `engine deficit` metric
UserScore	real4	Weighted value for the `user` metric
InstanceName	varchar(30)	Instance name
LoadProfileName	varchar(30)	Name of load profile used to generate the load score

Required parameters

None