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.

 

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: 15 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