Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

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