Dynatrace provides you with a number of ways to monitor your database performance.
How database activity is monitored
Support for SQL bind variables
Analyze database services
Improve database performance
Top database statements
Database service backtrace
Oracle database insights
Code-level based monitoring
Dynatrace provides you with insights into the database load, response times, and failure rates. Even connection acquisition 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 extension or by reporting important metrics via a custom device that you set up.
With code-level 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.
Currently we provide database insights for Oracle databases. Database insights provides an infrastructure monitoring perspective into your database, showing you why, for example, a particular statement is slow. With this additional data, you're able to resolve performance problems that are rooted deep in the database layer. See Oracle database insights.
Dynatrace monitors a number of database technologies out of the box with your OneAgent deployment, as well as using ActiveGate extensions you can run from an ActiveGate connecting remotely to your database server.