Submit a ticketCall us

Quickly Address Software Vulnerabilities
Patch Manager is an intuitive patch management software which extends the capabilities of WSUS and SCCM to not only patch Windows® servers and workstations, and Microsoft® applications, but also other 3rd-party applications which are commonly exploited by hackers. Learn more about our patch management solution.

 

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, last modified by Anthony.Rinaldi on Sep 15, 2016

Views: 12 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
14:02, 15 Sep 2016

Tags

Classifications

Public