monSysLoad

Description

Provides trended statistics on a per-engine basis. You need not have the mon_role role to query this monitor table. This monitoring table is available only for Adaptive Server Cluster Edition.

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 monitoring configuration parameters to use monSysLoad. These statics are always available and do not conflict with other monitoring tools, such as sp_sysmon.

Columns

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 one-minute average since start-up.
Max_5min	real	Maximum five-minute average since start-up.
Max_15min	real	Maximum fifteen-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.