Step 2: Drill into slow or stalled transactions to determine the root cause.

  1. From the left menu, navigate to Troubleshoot > Slow Response Times.
  2. In the lower pane of the Slow Transactions tab, click the Exe Time (ms) column to sort the transactions from slowest to fastest.
  3. Select a snapshot from the list and click Details.
  4. Review the Potential Issues list to see the longest-running method and SQL calls in the transaction.
  5. Click a potential issue and select Drill Down into Call Graph, or click Drill Down in the transaction flow map pane to see the complete set of call graph segments retained for this transaction.
  6. View the Time (ms) column to see how long this method execution takes relative to the transaction execution time.
  7. Click the HTTP link in the last column on the right to display the information details pane.
  8. Note theClass, Method,andLine Number(if available) represented by the execution segment. This information provides a starting point for troubleshooting this code issue.
If there are multiple slow or stalled transactions, repeat this step until you have resolved them all and then continue to Step 3.