Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA Documentation > 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. 

DPA_chart_PerfStack.png

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.

dataExplorer.png

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

Tags

Classifications

Public