2/6/2019 8:44 PM

10/26/2023 7:42 PM

  Watch a video about integration

When you integrate DPA with the SolarWinds Platform, information from DPA is displayed in the SolarWinds Platform Web Console. See the following sections to learn more:

• Why integrate DPA with the SolarWinds Platform? 
• How to integrate DPA with the SolarWinds Platform
• Learn more

Why integrate DPA with the SolarWinds Platform? 

After integration, the SolarWinds Platform includes new, DPA-specific widgets and expands the information available in other SolarWinds Platform widgets. Information from DPA, such as database wait time and query performance, improves your ability to troubleshoot slow response times or identify database instances that need additional resources.

After integration with the SolarWinds Platform, you can:

• View information from multiple DPA servers

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

• Integrate with SolarWinds Server & Application Monitor (SAM) or the server and application monitoring capabilities in Hybrid Cloud Observability Essentials

  If you have SAM or Hybrid Cloud Observability Essentials, integration with DPA adds views and resources that show query and database performance data next to application performance data. This information helps you determine if the root cause of performance problems is in the application or the database. In addition, the Database Instance category added to the Application Stack (AppStack) can be used to assess the overall database health and to troubleshoot performance and availability problems.

• Integrate with SolarWinds Storage Resource Monitor (SRM)

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

• Build SolarWinds Platform alerts and reports using information from DPA

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

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

  When you include DPA metrics with metrics from other SolarWinds 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?"

Database Performance Analyzer

How to integrate DPA with the Orion Platform 

Step 1: Install DPAIM 

In SolarWinds Platform 2022.2 and later, DPAIM is installed with the SolarWinds Platform. To install any SolarWinds Platform product, use the SolarWinds Platform Installer. 

Step 2: Integrate DPA servers 

To view information from DPA in the SolarWinds Platform, set up DPAIM and integrate one or more DPA servers. For instructions, see Set up the DPA Integration Module.

After you integrate your DPA server(s), the following are available in the SolarWinds Platform Web Console:

• The Databases dashboard is available in the My Dashboards menu.
• The AppStack includes a Database Instance layer.

Step 3: Create relationships 

After integrating one or more DPA servers, maximize the benefits of integration by creating relationships:

• If you have SAM or Hybrid Cloud Observability Essentials, create relationships between database instances and applications.
• If you have SRM, create relationships between database instances and storage objects.

For more information, see Manage database instance relationships.

Learn more 

For more information about using DPAIM, see the DPA Administrator Guide.