Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.0 Administrator Guide > DPA solutions > The DPA worksheet

The DPA worksheet

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

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

Tags

Classifications

Public