Database monitoring

For AppMon 6.3 and later, database monitoring is available on the DB instance level, giving insights into DBMS health, request frequency, execution plans and CPU and disk, comparable to the infrastructure overview of hosts and processes. In AppMon 2017 May, database monitoring is available for Oracle Database (including Oracle RAC), Microsoft SQL Server, MySQL and IBM DB2.

This complements the fully integrated, application-related capturing of connection pool usage, SQL statements and transaction response time contribution available for every DB call using JDBC, ADO.NET and PHP DB sensors in Java, .NET and PHP Agents respectively.

Data for any monitored database appearing in a PurePath automatically maps into the System Profile.

Database Agent

The Database Agent directly runs on the AppMon Collector and as such is delivered out-of-the-box and no other components are needed. It connects to a database instance and retrieves data every 30 seconds (measures) or on-demand (live view, execution plan).

Database Agent configuration

The only configuration necessary is to enter the connection credentials for the DBMS instances to be monitored and to select the Collector the Agent is part of.
See Settings > Dynatrace Server > Databases or Database Agent Configuration if you need instructions for the dialog box.

Auto-mapping of Database Agents into System Profiles

To merge global DB-monitoring data with application-specific data such as SQL statements, database agents dynamically map into the System Profiles if a database tier is detected on a PurePath and that same database instance is monitored. This mapping can be checked in the Status Overview Dashlet of a specific System Profile.

A database mapping into a specific System Profile is a prerequisite for viewing database monitoring data in the WebUI, as WebUI views are always filtered by the selected System Profile.

Access database monitoring data

Access dashboards from the Monitoring Overview breadcrumbs or by a drill-down from a specific database node in the Transaction Flow.

Monitored database instances overview

The list of all monitored database instances is available in the Databases item of the cockpit. Double click it to open the list of monitored database instances.

Drill down from Transaction Flow to Database Monitoring dashboards

There are several drill-downs from a database-related Transaction Flow node to specific dashboards, such as Database Health.

Permissions

The following permissions in AppMon control access to database monitoring:

  • Show Database Monitoring
  • Manage Database Monitoring