monSysLoad

(Cluster environments only) Provides trended statistics on a per-engine basis. You need not have the mon_role role to query this monitor table.

There is one row per engine per statistic, with the exception of kernel run queue length, which is reported only for engine number 0.

Averages are computed using an algorithm that eliminates momentary peaks and valleys and provides a an indication of overall trends.

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

The columns for monSysLoad are:

Name	Datatype	Description
InstanceID	tinyint	ID of the instance within the cluster.
EngineNumber	smallint	Engine to which this row belongs.
SteadyState	real	Average value for this statistic since Adaptive Server started.
Avg_1min	real	One-minute moving average for this statistic.
Avg_5min	real	Five-minute moving average for this statistic.
Avg_15min	real	Fifteen-minute moving average for this statistic.
Max_1min	real	Maximum 1-minute average since start-up.
Max_5min	real	Maximum 5-minute average since start-up.
Max_15min	real	Maximum 15-minute average since start-up.
Max_1min_Time	datetime	datetime at which Max_1min occurred.
Max_5min_Time	datetime	datetime at which Max_5min occurred.
Max_15min_Time	datetime	datetime at which Max_15min occurred.
Statistic		Name of the statistic this row represents:
Statistic		Percent CPU busy Percent I/O busy Run queue length Kernel run queue length	Outstanding disk I/Os Disk I/Os per second Network I/Os per second
Sample	float	Value of the metric at the last sample interval (that is, the current value of the metric).
Peak	float	The highest Sample value since the instance started (that is, the peak Sample value).
Peak_time	datetime	The date and time the Peak value was achieved.
StatisticID	int	A fixed identifier for this statistic. You may want to write applications to the fixed StatisticID instead of the localized Statistic name.