Each database page lists the most important metrics for that database. From here you can analyze response time or load details by clicking the link in the measurement section.
Access database performance details
From your home dashboard, click the Databases tile. This takes you to the Server-side services page which lists all the database services in your environment.
If necessary, you can use the Database filter on the Services page to narrow down the list of database services.
Analyze database performance
Click database metrics like Response Time, Load or Failure Rate in the infographic to see how these performance metrics are distributed over time.
To see which services make calls to this database, click the Services area of the infographic.
Analyze response time of database statements
On each database page you’ll find statistics related to database statements and messages regarding events related to this database. Use the statement links (for example, Query or Commit) to analyze response time for these detected statements.
Click Analyze database activity to see how often each client service contacts this database and what the results of these contacts are. You can then determine which of your services has the greatest impact on this database’s performance. You can even see the specific database statements that each service makes. Click a service name in the list above to filter the statement list.
Database activity in Dynatrace is more than just tracking all SQL statements executed by a service. We also know how many rows are retrieved and how often an application makes a network roundtrip to the database to do so. We include the time this takes, the fetch time, into the response time calculation.