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) > Database Performance Analyzer Getting Started Guide > Integrate DPA with the Orion Platform > Benefits of integrating DPA with the Orion Platform

Benefits of integrating DPA with the Orion Platform

Table of contents
No headers
DPA_GS_Home.png

Integrating DPA with the Orion Platform expands the information available in the Orion Web Console, making it easier to determine the root cause of performance problems. You can view database instance information alongside other environmental factors to get a more comprehensive view of issues affecting users and your IT infrastructure.

After integration, the Orion Platform displays DPA-specific resources that poll information directly from DPA. Integration also expands the information available in other Orion Platform resources. Information from DPA, such as database wait time, improves your ability to troubleshoot slow response times or pinpoint database instances that need additional resources.

After integration with the Orion Platform, you can:

  • View information from multiple DPA servers

    If you integrate multiple DPA servers with the Orion Platform, the Databases Summary view displays aggregated data from all servers. You can drill down to see information from a specific server.

  • Integrate with SAM

    If you have SAM, integration with DPA adds views and resources that are available only with integration. This information gives you an application-centric perspective of database performance and helps you determine if the root cause of performance problems is in the application or the database.

    In addition, a Database Instance category is added to the Application Stack (AppStack) provided by SAM. Use the Database Instance category to assess the overall health of your database instances and to troubleshoot performance and availability problems.

  • Integrate with SRM

    If you have SRM, integration with DPA adds views and resources that are available only with integration. This information gives you a storage-centric perspective of database performance and helps you determine if the root cause of performance problems is in the storage object or the database.

  • Build Orion alerts and reports using information from DPA

    You can create alerts in the Orion Web Console that are triggered by data collected from database instances. You can also select DPA resources when you create reports in the Orion Web Console.

  • Include DPA data in Performance Analysis (PerfStack™) dashboards

    When you include DPA metrics with metrics from other Orion Platform products, 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?"

For integration instructions and information about using these features, see the DPA Integration Module Integration Guide.

Last modified

Tags

Classifications

Public