Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

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