Use Database Monitoring

Use the Database Monitoring Overview page to find database instances, compare instance activity, and navigate to instance details.

Database Monitoring Overview page

From the left navigation menu, select APM, scroll down to the Database monitoring section, and select Overview. This page displays all known database instances within the timeframe you select.

Database Monitoring Overview page showing a time series chart and a table of database instances.

On the Database Monitoring Overview page:

  • The time series provides a summary of the top 5 instances with the highest total execution count, total duration, or total CPU time. Total duration (sec) identifies which instances are performing the most cumulative database work. Executions (count) identifies instances with unusually high call volumes or latency spikes.

  • The list of database instances is sorted by total duration of all normalized queries by default.

Use the following guidelines to interpret the data on this page:

  • If an instance has a total duration that is much higher than other instances, it might have more long-running queries.

  • In the list of database instances, it's a good sign when the Total duration column is about the same as the Total CPU time column. When there's a bigger difference between these two columns, applications are waiting, which means users are waiting too.

  • An upward trend indicates more load on the database.

  • High CPU usage means queries are spending more time using CPU than waiting on resources such as the network or I/O.

Tip: To find a specific instance, search for it by name. To see details for an instance, select the instance to navigate to its navigator. You can also use the time series to assess the overall health and performance of instances, use the Top 5 instances by menu to change the time series, use the selectors at the top of the page to filter by time frame or database type, or select a longer time frame, such as 2 days, to see more wait states.