Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

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

    File:Success_Center/New_Articles/DPA-MT/0H0/010/instances-with-highest-wait-time.png

  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.

    File:Success_Center/New_Articles/DPA-MT/0H0/010/top-sql-statements.png

  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

Tags

Classifications

Public