Monitor database platform instances
Monitor your database instances using Database Monitoring, Splunk IM, and Splunk APM features.
Overview page
From the left navigation menu, select APM, scroll down to the Database monitoring section, and select Overview.
On this page:
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).
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 that instance’s infrastructure page, and selects its Queries tab by default.
- 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.
Instance infrastructure page
From the Database Monitoring Overview page, select an instance to navigate to the infrastructure page for that instance.
The instance page is an existing page. Database Monitoring adds these new tabs to this page: