Use reports to communicate the long-term performance of your databases across your organization. You can capture the results of performance tuning, important database resources, and database trends. You can send reports to managers, team members, and customers. Reports supply evidence to support your work across the organization by highlighting database trends. Report examples include the top five resource bottlenecks and the highest SQL statement utilization.
Reports are different from the detailed data displayed in DPA charts. Detailed repository data are accessible for a shorter data storage period, typically 30 days. 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 data are summarized by hour and available for 90 days. After 90 days, the data are summarized by day and available for five years.
Reports show data trends over hours, days, months, and years. DPA requires a one-hour minimum of collection. Detailed repository data, with information down to the second, display information within 10 minutes of initial collection. SolarWinds recommends letting the repository collection run for 24 hours before creating a report.
Click Reports from the top of the SolarWinds DPA main page.
Under Create a New Report, select a Database Instance and Report Type. Some report types require an additional parameter, such as Wait Event or SQL Hash Value.
Click Report Options to change the default parameters, such as date range, interval, and time of day.
Under Reports, view saved reports. Filter reports by database instance.
Report Groups tab
A report group is a group of reports that are displayed together. Group reports together to see related data on one page.
Report Schedules tab
Report schedules are used to automatically email a report (or group of reports) at regular intervals. For example, you can create a schedule to email a list of the top 10 worst performing SQL statements every Monday at 9:00 a.m.