Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Database Performance Analyzer (DPA) > DPA Documentation > DPA 12.1 Administrator Guide > About DPA reports

About DPA reports

Created by Anthony.Rinaldi_ret, last modified by Melanie Boyd on Mar 13, 2019

Views: 927 Votes: 0 Revisions: 10

Use reports to communicate the long-term performance of your databases and supply evidence to support your work. Reports can capture the results of performance tuning and highlight database trends. You can send reports to managers, team members, and customers.

Differences between report data and detailed chart data displayed in the DPA interface

The data shown in reports differs from the detailed chart data shown in the DPA interface.

  Report data Detailed chart data
Storage period and granularity

Reports can show data captured over longer intervals and display long-term trends. To generate reports, DPA summarizes repository data to make long-term information available in a manageable size.

The previous 90 days of data are summarized by hour. After 90 days, data are summarized by day. This information is available for five years.

Detailed chart data are available for a shorter period, typically 30 days.

Charts can show information down to the second.

Data collection period Reports can be generated after a one-hour data collection period. SolarWinds recommends allowing a 24-hour data collection period before you create a report. Charts display data after a 10-minute data collection period.

Report types

DPA has many standard reports that include the most commonly used wait time statistics. You can customize the reports to meet your needs. 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.

For more information about working with DPA reports, see:

Last modified

Tags

Classifications

Public