Documentation forDatabase Performance Analyzer

About DPA reports

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 in the following ways:

  • 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 each report by selecting the database instance, time interval, and the items included (for example, the wait types or SQL statements). The following types of reports are available.

  • Average Wait

    Reports in this category show the average times for a single SQL statement or multiple SQL statements.

  • Top <element>

    These reports show the files, SQL statements, users, or other elements that are experiencing the longest waits. For example, the Top Files report shows the busiest files ranked by total I/O wait time.

  • Typical Day of <element> Wait

    These reports show the times of day when files, SQL statements, users, or other elements are experiencing the longest waits.

Learn more

To work with DPA reports, see the following topics: