Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > DPAIM 11.1 feature: DPA data in PerfStack

DPAIM 11.1 feature: DPA data in PerfStack

 Updated December 4th, 2017


With DPAIM 11.1, you can add DPA data to Performance Analysis (PerfStack™) dashboards. PerfStack dashboards can show how queries and database wait times relate to application and infrastructure performance. Both DBAs and non-DBAs can use DPA data in PerfStack to answer the question "Is it the database or the application?"

DPA data available in PerfStack

All DPA data that is available in the Orion Platform can be added to PerfStack dashboards. This includes:

  • Total wait time
  • Wait time by dimension (such as SQL, waits, programs, and users)
  • Drill downs to SQL text and SQL statistics
  • Database metrics
  • VM metrics
  • Custom metrics

Data from multiple database instances and multiple DPA servers can be included in the same dashboard.

Stacking data

Use PerfStack to stack different metrics and wait time dimensions in the same chart to find correlations. The following chart includes information from DPA, such as Wait Time by Type and Total Instance Wait Time, along with metrics from other Orion Platform products, such as Average CPU Load. 


Drilling in with the Data Explorer

The Data Explorer provides detailed information about data from one metric for a selected time period. In the following example, we inspected a slice of data from the Total Instance Wait Time chart. The Data Explorer lists the SQL statements executed during that time period, ordered by wait time. Expand a SQL statement to see part of the query text, and click Details for additional information.


Learn more

Learn more about PerfStack and the latest PerfStack improvements

See the DPAIM 11.1 release notes to learn more about other features, fixed issues, and known issues in this release.

Last modified