Slow Database Calls
Splunk AppDynamics displays a list of the slowest database calls. For each call, you can view specific call details and related business transaction snapshots. The list shows up to ten database calls with the longest execution time over the selected time frame, by tier and for all tiers. Each call shows:
- Call: SQL Query
- Avg. Time per Call (ms): the average time per call in milliseconds
- Number of Calls: the number of calls executed during the time range
- Max Time (ms): the maximum execution time in milliseconds
- View snapshots: a link to view existing transaction snapshots
App agents aggregate and report call data to the Controller every 15 minutes. Max Time determines which calls are displayed in the Slowest Database Calls list. For example for JDBC calls, Max Time must exceed 10 ms before Splunk AppDynamics tracks the call as a potential candidate for this list.
Slowest database calls are defined as:
- Max Time greater than 10 ms
- Top ten slowest
- Reported every 15 minutes
View Slowest Database Calls
To view slowest database calls, click .
On this page, you can do the following:
- If transaction snapshots are available for a call, you can click the View Snapshots link in the Snapshots column to select a snapshot and drill down to the root cause of the slowness.
- You can view explain plans by selecting a call and clicking View Details. In the dialog box, click Explain Plans. If parameter values are filtered out from the captured SQL, the Explain Plan feature is disabled.