Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.0 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: 39 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
14:02, 15 Sep 2016

Tags

Classifications

Public