Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

Home > Success Center > Database Performance Analyzer (DPA) > DPA Documentation > Database Performance Analyzer Getting Started Guide > Investigate performance issues > Investigate an increase in wait time

Investigate an increase in wait time

DPA_GS_Home.png

Updated: August 28, 2018

The following example shows how DPA can be used to find the root cause of an increase in wait time.

The problem

The wait time for a SQL statement that runs regularly has increased significantly.

The investigation

  1. From the DPA homepage, click the database instance that the SQL statement runs against.
  2. In the Top SQL Statements trend chart legend, click the SQL statement's name or hash value.

    The Query Details page shows the wait times for the past 30 days. You can see that the wait time started to increase around April 23.

    GS-qpa-top-waits.png

  3. Scroll down the page to review the charts. Notice that:

    • The Statistics chart shows that the Number of Executions is unchanged but Wait Time Per Execution increased significantly around April 23.

    • DPA detected a plan change and displayed the Plans chart automatically. The Plans chart shows that the increase in wait time occurred at the same time the plan changed.

    GS-qpa_plan-change.png

  4. On any chart, click the bar that represents April 23 to see more details about that day.

    The Top Waits and Statistics charts confirm that the wait times started increasing during the hour that the plan changed. You can also see that charts in the Instance Resource Metrics section don't indicate any resource pressure.

    GS-qpa_plan-change2.png

After determining the root cause, you can click the hash values in the Plans section to display each plan and find out what changed.

Last modified

Tags

Classifications

Public