Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

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

Views: 54 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