Integrating SolarWinds Database Performance Analyzer with the SolarWinds Orion Platform provides visibility to issues affecting your database performance in the Orion Web Console and the rest of your monitoring information. You can view database instance information alongside other environmental factors to get a more comprehensive view of issues affecting users and your IT infrastructure.
Integrating SolarWinds DPA information into your Orion Platform adds DPA-specific resources that poll information directly from DPA and expands the information available in other resources. Information from DPA, such as database wait time, improve your ability to troubleshoot slow response times or pinpoint database instances that need more resources.
There are two steps to set up the integration:
After the integration set up is complete, the SolarWinds Orion server saves the relationships made between DPA database instances and nodes, and applications monitored by the Orion Platform. The Orion server uses a service account created during integration set up to poll the DPA server for information and uses the relationships stored in the Orion database to display the related node or application. The Orion server requests information from the DPA server on the SSL port 8124 and provides links to DPA in the Orion Web Console that open to more detailed information. Users are automatically logged in to DPA with the service account credentials unless they already have a session open to DPA. No data from the Orion server is displayed in DPA.
Integrating adds a Databases section to the Orion Web Console to monitor your databases. The Databases Summary view is a dashboard displaying database performance across your organization, whether the databases are monitored in SolarWinds DPA or in an Orion Platform product.
Integrated database information is most helpful when used with SolarWinds Server & Application Monitor. This guide draws on many examples assuming you installed SolarWinds SAM.