Database health monitoring

The Database Instance Dashboard can be accessed by selecting a database instance either from the breadcrumb navigation or from the transaction flow. The data is queried every 30 seconds by the Database Agent.

Oracle

The following graphs are displayed for Oracle:

  • Sessions: Number of total and active sessions on the database instance.
  • User calls: Number of log ins, parses and execute calls.
  • Time Spent Breakdown: Show where the Oracle database uses most of its time (connection management, parsing or executing SQL statements or executing stored procedures).
  • CPU Usage: CPU usage of the foreground & background processes of the database as well as other non-database related processes on the host.
  • Disk I/O: Physical read & write from Oracle.
  • Total Wait Time: An Oracle process pauses when it can not get CPU time. The time spent waiting on resources is called wait time.

See also:

SQL Server

The following graphs are displayed for SQL Server:

  • Sessions: Number of total and active (running) sessions on the database instance.
  • Batch requests per sec: Number of queries that are being executed per second.
  • SQL Compilation & Re-Compilation:
    • Number of SQL compilations per second. Indicates the number of times the compile code path is entered. After SQL Server user activity is stable, this value reaches a steady state.
    • Number of statement recompiles per second. Counts the number of times statement recompiles are triggered. Generally, you want the number of recompilations to be low.
  • CPU: CPU usage of the database instance and other processes on the host.
  • Disk: Physical read & write by SQL Server.
  • Total Wait Time: Total time SQL Server waits for resources.

MySQL

The following graphs are displayed for MySQL:

  • Sessions: Number of active sessions on the database instance.
  • User requests: Number of executed user queries per second.
  • Executed queries by type: Division of queries by type.
  • Read/Write form all DB files: Number of bytes read from and written to all database files.
  • Total wait time: Total time spent waiting per second.
  • Table cache efficiency: Table cache hit rate.

AppMon 2018 February Aurora

The following graphs are displayed for Aurora:

  • User requests: Number of executed user queries per second.
  • Executed queries by type: Division of queries by type.
  • Read/Write form all DB files: Number of bytes read from and written to all database files.
  • Total wait time: Total time spent waiting per second.
  • Table cache efficiency: Table cache hit rate.

Graphs correspond to MySQL 5.6.

DB2

  • Sessions: Number of sessions on the monitored and non-monitored database instances.
  • Activities: Number of successfully completed, rejected, and cancelled activities.
  • Processing Time Breakdown: Processing time for database activities.
  • CPU: CPU usage of the database instance and other processes on the host.
  • Disk: Physical read & write times.
  • Total Wait Time: Total time spent waiting in milliseconds.