Performance variable
Description
Level
Category
Value
Average
Minimum
Maximum
Date and Time
Graph column
Graph Settings
Upper Alarm
Upper Warning
Lower Alarm
Lower Warning
Add
Remove
Graph
Performance variable
Description
Level
Category
Value
Average
Minimum
Maximum
Date and Time
Graph column
Graph Settings
Upper Alarm
Upper Warning
Lower Alarm
Lower Warning
Add
Remove
Graph
Performance variable
The name of the performance variable.
Description
The description of the performance variable.
Level
The level of the information collected by the performance variable. There are five levels:
Instance
Database
Table
Table space
Connection
Category
The category of the information collected by the performance variable. Each performance variable will return data associated with one of the following groups:
Agents
Buffer pool and I/O
Connections
Lock and Deadlock
Sort
SQL statement activity
Table
Unit of Work
Value
The value of the performance variable when a selected sample was taken. The default value is from the last sample.
Average
The average value for the performance variable calculated on the samples taken since monitoring began.
Minimum
The minimum value that the performance variable reached since monitoring began.
Maximum
The maximum value that the performance variable reached since monitoring began.
Date and Time
The value of the performance variable at the date and time specified in the column heading. If there is no data, then the selected performance monitor was not collecting information for this performance variable at that time.
Graph
A check mark in this column indicates that values for the performance variable will be graphed.
Graph Settings
Color indicates the color of the line for the performance variable in the graph.
Upper Alarm
The highest value the monitor will return for a performance variable before issuing the upper alarm actions set for that performance variable. If there is no data, then no alarm has been set. Alarms can be enabled or disabled.
Upper Warning
A value (less than the upper alarm value) used to warn you that a performance variable is approaching its upper alarm value. When the upper warning value is reached, the upper warning actions set for the performance variable are issued. If there is no data, then no warning has been set. Warnings can be enabled or disabled.
Lower Alarm
The lowest value the monitor will return for a performance variable before issuing the lower alarm actions set for that performance variable. If there is no data, then no alarm has been set. Alarms can be enabled or disabled.
Lower Warning
A value (greater than the lower alarm value) used to warn you that a performance variable is approaching its lower alarm value. When the lower warning value is reached, the lower warning actions set for the performance variable are issued. If there is no data, then no warning has been set. Warnings can be enabled or disabled.
Add
Click the Add push button to add performance variables to the performance monitor being displayed. The Add window opens.
Remove
Click the Remove push button to remove selected performance variables from the performance monitor being displayed.
Graph
Click the Graph push button to add or remove selected performance variables on the performance monitor's Details graph.
