Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register here.

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: 489 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