Page History
...
The most important part of the previous screenshot is the Average Active Sessions (AAS) graph. AAS shows the performance of the database measured in the single powerful unified metric AAS. AAS easily and quickly shows any performance bottlenecks on the database when compared to the Max Engines (for Sybase) or Max CPU (for Oracle) the Max CPU line. The Max Engines line is a yardstick for performance on the database. When AAS is larger than the Max CPU line, there is a bottleneck on the database. Bottleneck identification is that easy.
...
| DBMS | Wait Event Category | ||
|---|---|---|---|
| IBM DB2 | Fetch, Cursor, Execution, Operation, Transaction, Connectivity, Lock, Other | ||
| Oracle | On CPU, System I/O, User I/O, Cluster, Application, Configuration, Commit, Other | ||
| SQL Server | CPU, Lock, Memory, Buffer, I/O, Other | Sybase | CPU, Lock, Memory, I/O, Network, Other |
* A chart legend displays a color and code scheme for executing and waiting session categories, in the upper right-hand corner of the view.