Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.1 Administrator Guide > DPA solutions > Correlate response time with system resources

Correlate response time with system resources

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

Views: 74 Votes: 0 Revisions: 6

You can compare the response time results with system resource usage such as CPU, I/O, and memory. You will learn if specific response time spikes are related to server resources by comparing chart results at the same times.

  1. On the home screen, click an entry in the Database Instance list.
  2. Below the Top SQL Statements chart, click the Resources tab to see the default resources. Make changes with the controls to the right of each resource.

    File:Success_Center/New_Articles/DPA-110-MT/0K0/resources-tab.png

    Viewing the top Wait Types/Events will help you determine which resources have the biggest effect on database response time. For example, if you have db_file_sequential_read as a top Wait Type/Event, you should monitor storage layer resource metrics.

  3. Click Add Resource Chart, and select the two or three resources of most interest.
  4. Note the resource names in the DPA worksheet.

 

Last modified

Tags

Classifications

Public