Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

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: 80 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.

    File:Success_Center/New_Articles/DPA-110-MT/0M0/current-tab.png

  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

Tags

Classifications

Public