The Databases app gives you a unified, vendor-agnostic overview of all your Extensions Framework 2.0–monitored databases.
Before you start
- The Databases app uses data collected by Dynatrace SQL extensions. To use it, you need to configure your database monitoring first with one of the Dynatrace-provided extensions or develop your extensions using the SQL data source.
- Databases comes preinstalled in your Dynatrace environment, but your administrator needs to assign specific permissions to users of the app. Check the required permissions in the Hub overview of the app (Technical information tab).
Get an overview of your database landscape
In Dynatrace, go to Databases and select Overview.
The Database overview tab offers a summarized view of all your monitored database instances.
At a glance, you can see visualizations of:
The database types monitored in your environment
The statuses of your monitored databases
The most time-consuming statements from all your instances
See the list of your instances
Select the Instances 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 andcredentials to access them
The feature sets you'd like to monitor
The Database instances table displays the most important metrics critical to the database performance, such as Davis-detected problems, status, CPU usage, number of active sessions, number of user calls, and memory consumption.
Track most resource-expensive statements
If the extension provides related information, you can select the chart icon in the Statement performance column to display a Statement performance analysis to track the performance of the most resource-expensive statements.
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 Custom to choose up to three metrics to adapt the context to your needs.
Get the overview of a single instance
For an overview of a single instance, select the Instance name in the Database instances table. From here, you can analyze all the metrics collected by the extension.
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.
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.