Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

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