The dashboard for each individual database provides the most detailed information about your database.
You can access the Database Dashboard in one of the following ways:
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 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:
Top 10 SQL Wait States: 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 is 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.
Average number of active connections: The average number of sessions that are actively running a query during the selected time period.
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.
Accessing Metric Brower
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.
For full-screen viewing, click Quick Overview: Database Monitoring Dashboards.