Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.1 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: 495 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