monSysLoad

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.

Columns

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 the SAP ASE 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: 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.