Provides trended statistics on a per-engine basis.
Name |
Datatype |
Description |
|---|---|---|
InstanceID |
tinyint1 |
ID of the instance within the cluster. |
EngineNumber |
smallint2 |
Engine to which this row belongs. |
SteadyState |
real4 |
Average value for this statistic since start-up. |
Avg_1min |
real4 |
One-minute moving average for this statistic. |
Avg_5min |
real4 |
Five-minute moving average for this statistic. |
Avg_15min |
real4 |
Fifteen-minute moving average for this statistic. |
Max_1min |
real4 |
Maximum one-minute average since start-up. |
Max_5min |
real4 |
Maximum five-minute average since start-up. |
Max_15min |
real4 |
Maximum fifteen-minute average since start-up. |
Max_1min_Time |
datetime(8) |
datetime at which Max_1min occurred. |
Max_5min_Time |
datetime(8) |
datetime at which Max_5min occurred. |
Max_15min_Time |
datetime(8) |
datetime at which Max_15min occurred. |
Statistic |
varchar(30) |
Name of the statistic this row represents. |
Sample |
real4 |
Value of the metric at the last sample interval (that is, the “current” value of the metric). |
Peak |
real4 |
The highest Sample value since the instance started (that is, the peak Sample value). |
Peak_time |
datetime(8) |
The date and time the Peak value was achieved |
StatisticID |
smallint2 |
A fixed identifier for this statistic. You may wish to write applications to the fixed StatisticID instead of the localized Statistic name. |
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 the “exponential moving average” technique, not geometric averaging. This makes averages values more resistant to momentary peaks and valleys.
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.
None
