Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.0 Administrator Guide > DPA solutions > Diagnose current performance issues

Diagnose current performance issues

Table of contents
No headers
Created by Anthony.Rinaldi_ret, last modified by Anthony.Rinaldi_ret on Sep 15, 2016

Views: 53 Votes: 0 Revisions: 6

When a problem is occurring, you must be able to diagnose it immediately.

  1. Locate the Instances with Highest Wait Time resource on the home screen.
  2. For today's date, click the bar that represents the instance with the highest wait time.
  3. Click the Current view to examine response time and resources from the past hour.


  4. Click an interval, such as 9:50AM above, to drill down into the top SQL queries and performance for smaller time increments.
  5. Click the Timeslice tab to see a per-minute breakdown of the response time and resource data.
  6. Examine the response time charts, and scroll down to the Resources section to identify a possible correlation.
  7. Record current queries and wait events that show performance problems in the DPA worksheet.
Last modified
14:02, 15 Sep 2016