Each database has its own dashboard and is listed in the Database Servers List.
The Database Server 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.
To access the Database Server List
In the left navigation pane, click Servers -> Databases.
- To sort the servers based on the data in a particular column, click the column header.
- To filter the list, enter the string to filter on in the filter field.
To delete databases from the list
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.
The Database Dashboard
Access a dashboard from the Databases List.
To access a Databases Dashboard
1. In the left navigation pane click Servers -> Databases.
2. From the Databases List select a database.
3. Click View Dashboard.
How the Database Dashboard is Organized
The Action menu provides these actions for a remote service:
- Rename Backend: Renames the database.
- Resolve Backend to Tier: Associates the database with the tier that you select so that the backend appears in the grid view of the tier and not as an independent component ("unresolved backend") on the application dashboard flow map. You can reverse this operation from the Configure Backends resolving to this Tier item in Actions menu in the tier dashboard.
- Delete Backends: Removes instances of the database from the controller and all agents. An agent can re-discover the database and register it with the controller.
The dashboard has two tabs:
The Dashboard tab displays information about calls to the database:
- Flow map: shows traffic from the calling tier to the database. See Flow Maps.
- Backend Properties: varies according to database type.
- Key Performance Indicators: See KPI Graphs.
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 Behavior Learning and Anomaly Detection and Configure Baselines.
Slowest Database Calls Tab
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.
Linking to AppDynamics for Databases
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.