Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

Register now.

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


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

Views: 841 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