The dashboard for each individual database provides detailed information about your database.
To view database collectors, users need a role with the Can View All Collectors permission.
Access the Database Dashboard
You can access the Database Dashboard in one of the following ways:
- In AppDynamics Home, on the Databases card, click the name of the database for which you want to see the Database Dashboard.
- In the Databases overview window, click the name of the database for which you want to see the Database Dashboard.
Features of the Database Dashboard
On the Database Dashboard you can:
Click the dropdown arrow next to the database Collector name at the top of the page to choose a database that you want to see the dashboard for.
Click the down-arrow next to the clustered database Collector name to navigate between different nodes of the cluster.
Click the status icon below SERVERS in the top section of the dashboard to go directly to Events where you can see any recent events..
On the Database Dashboard you can see the following information:
- Server Health: Server Health at the top of this window indicates the extent to which health rules are being violated:
- Green - Healthy server
- Yellow/orange - server with warning-level violations
- Red - server with critical-level violations
- Type: The database type.
- Time Spent in Database and Executions:
- Load - At a glance, you can see the total number of calls (transactions for PostgreSQL databases) during the specified time period and the number of calls for any point in time.
- Time spent in Database - The total time spent executing SQL statements during the specified time period.
- Changes - Changes made to the database configuration parameters.
- Max CPU - It displays the CPU cores present in the database server and is disabled by default. The CPU core count is collected using SQL (for Oracle, DB2, and MSSQL) and Hardware monitoring (if enabled for MySQL, PostgreSQL and Sybase).
- Top 10 SQL Wait States (not available for Couchbase): Activities that contribute to the time it takes the database to service the request. The wait states consuming the most time may point to performance bottlenecks. For example, a db file sequential read wait state may be caused by segment header contention on indexes or by disk contention. See your database platform documentation for descriptions of the SQL wait states. For example, the following was developed from information in a Microsoft Customer Service blog for SQL Server:
- Wait State - CHECKPOINT_QUEUE
- Description - Used by background worker that waits on events on queue to process checkpoint requests.
- Recommended Action - You should be able to safely ignore this one as it just indicates the checkpoint background worker is waiting for work to do. I suppose if you thought you had issues with checkpoints not working or log truncation you might see if this worker ever "wakes up". Expect higher wait times as this will only wake up when there is work to do.
- Top 10 Phases (Couchbase only): The phases that have processed the most documents.
- Average number of active connections: The average number of sessions that are actively running a query during the selected time period.
Accessing the Comparison Report
Click on any data point to view the time comparison report, which shows query run times and wait states 15 minutes before and 15 minutes after the selected time.
The CPU, Memory, Disk I/O, and Network I/O graphs display when the Database Agent has been configured to also monitor the database host hardware. See, "Configure the Database Agent to Monitor Server Hardware" on Add Database Collectors.
- CPU: The CPU graph shows the relative percentages of CPU processing time used for handling system and users processes.
- Memory: The Memory graph shows the percentage of total memory in use at any point in time.
- Disk I/O: The Disk I/O graph shows disk usage, the volume of data read and written.
- Network I/O: The Network I/O graph shows network activity, the volume of data sent and received.
Accessing the Metric Browser
To see more information about a specific metric, double click any point on the graph and the Metric Browser opens displaying that metric. You can then hover over a point on the graph in the Metric Browser for more information about the metric. This feature is available for all the graphs except the SQL wait states graph.