Databases app
Latest Dynatrace
The 
Databases app gives you a unified, vendor-agnostic overview of all your Extensions Framework 2.0–monitored databases.
Get started
Databases uses data collected by Dynatrace SQL extensions. To use it, you first need to configure your database monitoring with one of the Dynatrace-provided extensions. These cover the most popular database vendors.
Additionally, you can develop your own extensions using the SQL data source or reach out to our Extension Services team for help supporting other databases vendors.
Permissions
The following table describes the required permissions.
Installation
Make sure the app is installed in your environment.
The Overview tab presents a summarized view of all your monitored database instances. At a glance, you can see the visualizations of:
- Database instances that you are monitoring (both Healthy and Unhealthy)
- Database hosts (if the machine running the database has OneAgent installed)
- The video of the Databases app capabilities
- Links to useful resources (such as ready-made dashboards and workflow templates)
Select the Explorer tab to list all your monitored instances.
The monitored instances are presented here as defined in your monitoring configuration:
- From where the extension runs
- The endpoints that the extension calls to collect data and credentials to access them
- The feature sets you'd like to monitor
The Database instances table displays the most important data in the following perspectives:
-
Health—to see the unified statuses of your monitored databases and Davis-detected problems.
-
Utilization—to see the common metrics across all database vendors such as: CPU usage, memory consumption, number of user calls, active sessions.
-
Host—to see the most important metrics about the machine that database instance is running on with the option to access
Infrastructure & Operations for further details.
For an overview of a single instance, do one of the following:
-
Go to the Explorer tab and select the instance name in the Database instances table.
-
In the rightmost column, select the statement performance icon.
From here, you can access the Entity details panel and analyze all the metrics collected by the extension.
Statement performance
If the extension provides related information, you can display a Statement performance analysis to track the performance of the statements that consume the most resources.
To focus your analysis, you can:
- Set Filter statements to a search string.
- Set Contextual analysis to the context of the predefined metrics (Time, CPU, Disk, or Waits) or select the column settings icon to customize the columns and adapt the context to your needs.
- Select Request execution plan to understand how the database executes the statement for optimization.
Analyze logs in context
To get an overview of monitored log events, select the Logs tab of the instance overview. You can also run a DQL query that fetches the latest log events in the context of the instance.
Analyze the instance in context
To pass the instance context to other Dynatrace apps, in the upper-right corner of the instance overview, select 
> 
Open with. For example, you can analyze your instance in Smartscape Topology or your cloud monitoring context.
In Databases , Davis CoPilot can provide natural language explanations of execution plans, breakdowns of relevant details, and recommendations on how to improve statement performance.
Query execution plans provide detailed information on how a database will execute an SQL query. While these provide the raw data on how to improve query performance and reduce resource consumption, they require expert knowledge to read and interpret. With the Davis CoPilot integration, non-expert database users, such as developers, gain the knowledge they need to optimize their application performance and database utilization.
To summarize an execution plan with Davis CoPilot:
- In Databases , go to Explorer.
- In the rightmost column, select the statement performance icon.
- Expand the statement you would like to improve. If an execution plan is not already available, you can request one.
- Select the Execution plan tab, and select Summarize with Davis CoPilot.
- Davis CoPilot Chat will open and auto-execute the predefined prompt.
- Davis CoPilot will generate a response with insight on the selected database execution plan.
For more details, see Davis CoPilot.
Your feedback matters
This application is a brief introduction to planned end-to-end observability and intelligent tracing for database applications.
Please share your feedback about the application via a dedicated Dynatrace Community thread or by raising a product idea.
