No special setup or configuration is required to monitor your databases with Dynatrace. Database calls that are made through monitored Java, .NET, PHP or Node.js processes are monitored automatically as long as the interaction with the database relies on a supported database framework (for example, JDBC, ADO.NET, or PDO). Just ensure that OneAgent is installed on the host that runs your application server and Dynatrace will take care of the rest, as long as deep monitoring is active for the calling processes. As soon as the first calls to your database are monitored, your Databases page will be updated with the new database entry.
Dynatrace provides you with insights into the database load, response times, and failure rates. Even connection aquisition times can be monitored. As Dynatrace is a full-stack solution, it also provides insights from the infrastructure perspective of your databases—just by deploying OneAgent on the database hosts. This adds a second view into health metrics like CPU or memory utilization and even network health. Even log files are included in the analysis. If you can't install OneAgent on a database host itself, you can get visibility through our integrations with cloud providers (AWS and Azure) by using an ActiveGate plugin or by reporting important metrics via a custom device that you set up.
With Dynatrace database monitoring you can:
- See the impact of your database statements on the response times of your services.
- Find expensive database statements based on the service calls or user actions from which they originate.
- Find out which services talk to databases most frequently.
- See how much load is placed on your databases by individual services.
- Understand why some statements are slow.
- Be notified of increased SQL statement costs and execution.