- 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.
- Load and Time Spent in Database:
- Load - At a glance you can see the total number of calls during the specified time period and the number of calls for any point in time. The number of calls to the database directly correlates with database performance; the more calls there are, the longer it takes to respond to each call.
- Time spent in Database - The total time spent executing SQL statements during the specified time period.
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 active connections The average number of sessions that are actively running a query during the selected time period. A connection is a session established between a database client and a server.
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.