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 > 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: 457 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.


    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