AppDynamics Application Intelligence Platform
Each database has its own dashboard and is listed in the Database Servers List.
AppDynamics displays all detected database servers on the database server list along with the key performance indicators of calls to them: response time, calls, calls per minute, errors, and errors per minute.
In the left navigation pane, click Servers -> Databases.
1. Select the database or databases that you want to delete from the list.
2. Click the delete icon.
The database or databases no longer appear in the UI.
Access a dashboard from the Databases List.
1. In the left navigation pane click Servers -> Databases.
2. From the Databases List select a database.
3. Click View Dashboard.
The Action menu provides these actions for a remote service:
The dashboard has two tabs:
The Dashboard tab displays information about calls to the database:
The Compare menu is visible when the Dashboard tab is selected.
By default the performance displayed in the dashboard is compared against the daily trend, which is the performance over the last 30 days. From the Compare menu you can direct AppDynamics to use a different baseline or no baseline. You can also configure baselines. For more information about baselines see Detect Anomalies Using Dynamic Baselines and Configure Baselines.
The Slowest Database Calls tab lists up to ten calls to the database with the longest execution time, by tier and for all tiers.
Each call shows the SQL Query, Average Time, Number of Calls during the time range, and maximum execution time (Max Time). The Max Time is used to determine which calls are displayed in the Slowest Database Calls list.
If transaction snapshots are available for a slow call, you can click View Snapshots link. From there you can select a snapshot and click View Transaction Snapshot to drill down to the root cause of the slow database call.
Users of AppDynamics for Databases can link to that product by right-clicking on a database from the database list or from the database icon on any flow map.
This linkage gives you deep visibility into the performance of an application's SQL queries.