PDFs

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Access the Database Dashboard

To You can access the Database Dashboardthe Database Dashboard in one of the following ways:

  • From AppDynamics Home, double-click the name of the database you want to see in detail on the Database Dashboard.

Or

  • From the Databases overview window, click

...

  • the name of the database you want to see in detail on the Database Dashboard.

Features of the Database Dashboard

...

  • 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 statesFor 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 connections established with the database at any point in time  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 Configure 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, volume of data read and written.
  • Network I/O: The Network I/O graph shows network activity, volume of data sent and received.

...

Tip
titleAccessing 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.

Watch the Video

HTML
<style type="text/css">.vidyard_player{width: 600px; }.vidyard_player > span{max-width: 600px !important; max-height: 360px!important;margin-left:0!important;}.innerContainer{position: relative; display: block; width: 100% !important; height: 0; }</style><script type="text/javascript" id="vidyard_embed_code_CDkSBkL3SnTPNvJKUagkPY" src="//play.vidyard.com/CDkSBkL3SnTPNvJKUagkPY.js?v=3.1.1&type=inline&second=90"></script>

For full-screen viewing, click Quick Overview: Database Monitoring Dashboards.