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 and later, database monitoring is available for Oracle Database (including Oracle RAC), Microsoft SQL Server, MySQL, Aurora 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.
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 Databases 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 Database Instances dashlet. To access it:
- AppMon 2017 May In the Cockpit, double-click Databases node.
- AppMon 2018 February In the Server section of the sidebar, click Databases.
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.
The following permissions in AppMon control access to database monitoring:
- Show Database Monitoring
- Manage Database Monitoring
It is necessary to have them to be able to change the Database Agents configuration.