Performance variable
Description
Level
Category
Graph column
Graph Settings
Upper Alarm
Upper Warning
Lower Alarm
Lower Warning
Add
Remove
Graph
Performance variable
Description
Level
Category
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
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 on the Add push button to add performance variables to the performance monitor being displayed. The Add window opens.
Remove
Click on the Remove push button to remove selected performance variables from the performance monitor being displayed.
Graph
Click on the Graph push button to add or remove selected performance variables on the performance monitor's Details graph.
