Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.0 Administrator Guide > Reports


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

Views: 115 Votes: 0 Revisions: 7

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.

Access reports in DPA

Click Reports from the top of the SolarWinds DPA main page.

Reports tab

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.

See also:

Last modified
14:08, 15 Sep 2016