On this page:
Database Visibility provides overall views of your databases that show key performance indicators.
Access the Databases Window
From AppDynamics Home, click Databases.
Features of the Databases Window
On the views of the Databases window you can:
- Show only databases meeting certain criteria by enter search criteria in the search box on the top right of the page.
- Click Filters to show only databases meeting certain search criteria, such as criteria that describes Health, Load, Time in database, or Type.
- Click the + symbol to add a new database Collector.
- Click Actions to export the data on this window in a .csv formatted file that is automatically downloaded to your specified downloads directory.
- Click View to switch between card and list view.
- See the overall performance of your databases and if there are any critical issues with them. The server health or status indicates whether critieria has been met for normal, warning or critical health rules. The green check mark indicates that the database is operating within normal conditions, the red exclamation mark indicates that at least one critical health rule has been violated.
- Click the name of the database to switch to the Database Dashboard for that specific database.
Databases Card View
From the Databases card view, you can see:
- The Total Executions graph that provides insight into the total number of queries monitored for the database over the selected time period. This metric is expressed in millions of queries.
- The Time in Database graph that indicates the total time spent executing those queries during the selected time period. This metric is expressed in hours, minutes, and seconds.
- CPU Usage metrics that when enabled shows the percentage of CPU capacity consumed by the database.
Databases List View
From the Databases list view, you can:
- Click View Options to turn the spark charts on and off.
- Get to the databases you want to see quickly if you are monitoring many databases.
- Click on any point in the spark charts to see a metric for that point in time. For example, clicking on a point in the Queries Trend shows how many queries were monitored at that time.
- Click on a column name to sort the list on that key.