We’ve received a lot of feedback regarding Dynatrace database analysis and we’ve optimized our approach based on your input. Dynatrace database analysis is now faster, easier to use, and provides more detailed information. Each database Services page now includes an Analyze database activity button beneath the Response time chart.
Click the Analyze database activity button to go to a detail page that features a layout you may already be familiar with. This page layout looks a lot like the Dynatrace Services details page. What’s new is that all relevant database statements executed during the last 30 minutes are listed at the bottom of the page. By default, database statements are sorted based on median response time. Alternatively, you can sort database statements based on number of executions, failure rate, total time, or slowest response time.
Note that this new database statement table view is similar to the new response time analysis view. Click any statement to view full details:
In addition to providing full details about each statement’s execution, Dynatrace also shows you which services executed each selected database statement. With this approach you can filter the statements based on database-statement type. Click any database method, for example a query, to view only the query statements.
The real power of the new database analysis views reveal themselves when it comes to analyzing performance degradation. You can immediately see which statement is responsible for a given slowdown. In the example below, the detected slowdown was caused by a single statement (
delete from Booking where id=?). The statement that caused the database slowdown was executed by the JourneyService.