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 > The DPA worksheet

The DPA worksheet

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

Views: 662 Votes: 0 Revisions: 5

Record your actions from the preceding pages.

Identify the top three query problems

Record three SQL statements by hash value:

  1.  
  2.  
  3.  

Assign names to the three SQL statements identified above:

  1.  
  2.  
  3.  

Correlate response time with system resources

Record the system resources that correlate with bottlenecks in response time:

  1.  
  2.  
  3.  

Determine wait bottlenecks that delay response time

Record the program generating the most wait time:

  •  

Record the top waits for each SQL query:

SQL1 name:

Wait Percentage of Time
   
   
   

SQL2 name:

Wait Percentage of Time
   
   
   

SQL3 name:

Wait Percentage of Time
   
   
   

Diagnose current performance issues

Record current queries and wait events:

Current Queries Current Wait Events
   
   
   
Last modified

Tags

Classifications

Public