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 > 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

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.

Benefits of integrating DPA with the Orion Platform

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

    video-icon.png
    Check out this video (3:44) on integrating DPA and SAM.
     

    If you have SAM, integration with DPA adds views and resources that are available only with integration. For example, you can see which applications are querying a database, and then click through for information about response time.

    apps-using-all-my-databases.png

    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. Database administrators and system administrators can use the DPA and SAM integration to:

    • Analyze database performance within the context of a specific application.
    • Monitor applications, databases, and server performance from a single interface, and drill down to find the root cause of slow application performance.
    • Understand the relationships and dependencies among the layers of infrastructure from the perspective of an application.

    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. You can see contextually relevant information on storage objects related to databases monitored by DPA, and correlate storage health and performance with the databases mapped to the storage objects. 

    storage-objects-by-perf-risk.png

    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?"

How do I integrate DPA with the Orion Platform?

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

Last modified

Tags

Classifications

Public