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 > Identify the top three query problems

Identify the top three query problems

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

Views: 90 Votes: 0 Revisions: 7

The efficiency of processing SQL queries is one of the most important indicators of database performance. SolarWinds recommends determining which queries are creating the largest delays in the database. The response-time measure is critical because it reflects where users wait on the database. Identifying and improving response time for SQL queries has the biggest effect on the service delivered by your database.

Before continuing, let SolarWinds DPA capture at least two days of performance data so you have a representative sample.

  1. Locate the Instances with Highest Wait Time resource on the home screen. The legend entries are sorted by total database wait time.


  2. Pick a day, and click the bar that represents the instance with the highest wait time.
  3. The Trends view displays the top SQL statements for the day.

    The length of each bar represents the total wait time across all sessions. The longer the bar, the longer the users had to wait for a response from the database. The colors represent the individual SQL queries, identified by hash values accumulating the response time delay.


  4. Note the top three SQL query hash values with the highest performance priority, and enter this information into the DPA worksheet.
  5. Click the first SQL hash number in the legend to load the SQL Properties dialog.
  6. Assign a name to the query, and click OK. This name makes the query more recognizable in DPA reports.
  7. Repeat steps 5 and 6 for the second and third hash numbers.
Last modified