Monitor database platform instances

Monitor your database instances using Database Monitoring, Splunk IM, and Splunk APM.

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.

Screenshot showing the Database Monitoring Overview

On the Database Monitoring Overview:

  • The time series provides a summary of the top 5 instances with highest total execution count, total duration, or total CPU time.

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

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

  • 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 it means that applications are waiting, which in turn means that users are waiting.

  • A trend means more load on database.

  • High CPU usage means queries aren't waiting. In other words, their time is spent using the CPU (query is running), rather than in some wait state (network, i/o, and so on).

Tip:

Actions you can take:

  • To find a specific instance, search for it by name.
  • To see details for any instance, select it. This navigates you to the navigator for that instance.
  • Use the time series to quickly assess the overall health and performance of the instances.
  • To toggle the view of the timeseries, select a value from the Top 5 instances by menu.
  • To filter by time frame or database type, use the selectors at the top of the page.
  • To see more wait states, select a longer time frame, like 2 days.

A navigator is a collection of resources that you can use to monitor your infrastructure components.

The navigator for a database instance has multiple tabs which may not all be visible if you don't have a Database Monitoring license. Depending on how you navigated here, you'll land on a different tab:

  • From the Database Monitoring Overview page, when you select an instance you land on the Queries tab of the navigator.

  • From Infrastructure > Overview > Datastores > any database instance tile you'll land on the database instance tab, as in the screenshot below. This tab is named differently for different database types. In the screenshot, the tab is named Oracle DB instance.

Screenshot of database platform navigator.
Tip: See alerts associated with this instance in the upper right corner of the navigator.

If you have a Database Monitoring license the instance navigator includes these tabs: