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 about our patch management solution.

 

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.0 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, last modified by Anthony.Rinaldi on Sep 15, 2016

Views: 24 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
14:02, 15 Sep 2016

Tags

Classifications

Public