Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

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

DPAIM 11.1 feature: DPA data in PerfStack

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