The Performance menu provides access to the details of the monitored
database. The screens available within the Performance menu contain
information about the queries running on the database. The following screens are available:
-
Database Load - detailed
analysis of queries executed on the instance
-
Waits/Locks - expectation
analysis
- Mutexes - mutual exclusions
-
SQL Analyze - analyzing the
impact of queries on performance
-
SQL Details - query details
-
Load trends - verification of
performance trends
-
Compare Trends - trend
comparison engine
-
Top SQL - query impact analysis of
key performance components
-
SQL 3D - query impact analysis on
key performance components - 3D chart
-
Top Day - verification of top
queries for a given day
-
Slow SQL - analysis of slow
queries
-
OS Stat - performance analysis from
OS level