Step 3: Check for slow database or remote service calls on the backend.

Splunk AppDynamics collects metrics about the performance of business transaction calls to the databases and remote servers from the instrumented app servers. You can drill down to the root cause of slow database and remote service calls.

  1. Click Troubleshoot > Slow Response Times, then click the Slowest DB & Remote Service Calls tab.
  2. Select a call from the list and click the View Snapshots link to show a list of Correlated Snapshots.
  3. Click the Exe Time (ms) column to sort the transactions from slowest to fastest.
  4. Select a transaction and click Drill Down.
  5. Select a potential issue from the Potential Issues list
  6. Click Drill Down into Call Graph to go directly to that point in the call graph, or click Drill Down in the flow map pane to see the complete set of call graph segments retained for this transaction.
  7. Review the Time (ms) column and select the transaction with the longest execution time for this method relative to the transaction execution time.
  8. Select the DB & Remote Service Calls tab.
  9. Do you see one or more slow calls on the SQL Calls or Remote Service Calls tabs?
    • If Yes – Go to Step 4 to drill down and find the root cause.
    • If No – Go to Step 5 to determine if the problem is affecting all nodes in the slow tier.