Submit a ticketCall us
Home > Success Center > Database Performance Analyzer (DPA) > DPA Documentation > DPA 11.1 Administrator Guide > Reports > Report types

Report types

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

Views: 592 Votes: 0 Revisions: 5

SolarWinds DPA has many standard reports that include the most commonly used wait time statistics. You can customize the reports to see more detailed trends in your databases. Available reports include:

Top SQLs

This report shows the top five SQL statements ranked by total wait time across a custom interval. You can change the report to display the top 10 or select specific SQL statements from the SQL Statements tab on the Report Properties dialog. The report will show a descriptive name for the SQL if it has been defined.

Top Waits for single SQL

This report identifies the top wait events (up to 50), ranked by wait time, for a specific SQL statement.

Top SQLs for single Wait

This report identifies the top SQL statements for a single database wait.

Typical Day of Wait

This report displays a bar graph showing the average hourly wait time for a database. It displays the distribution of average wait time versus time of day.

Typical Day of Wait for single SQL

This report displays a stacked graph showing average hourly wait time for the top waits contributing to the total wait time for an individual SQL statement. The top of the bar is the sum of all other waits. This report can identify the peak loads during your business hours based on long-term observation of the system.

Top Waits

This report charts waits for an entire database. SolarWinds DPA displays the waits with the highest accumulated wait time.

Top Programs

This report displays the total accumulated wait time for programs.

Top Files

This report displays the busiest files ranked by total I/O wait time. SolarWinds DPA calculates the total wait time for all I/O operations on each file for selected intervals.

Last modified