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.
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.
Reports in this category show the average times for a single SQL statement or multiple SQL statements.
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.
To work with DPA reports, see the following topics:
- Access and run DPA reports
- Create a DPA report
- Search for a SQL statement to report on
- Schedule a DPA report for delivery
- Create a DPA report group