Documentation forDatabase Performance Analyzer

Viewing DPA data in the SolarWinds Platform Web Console

After you have integrated DPA with the SolarWinds Platform, you can view information from DPA in the SolarWinds Platform Web Console. Click My Dashboards > Databases > Databases Summary.

  • If you integrated multiple DPA servers, the Databases Summary view displays resources that gather information from all of the servers.
  • If you integrated one DPA server, the Databases Summary view displays resources with information from that server.

Review the resources and in addition to critical issues or warnings, look for anything that looks out of the ordinary. For example, in the Instances with the Highest Wait Time resource, are there any bars or bar segments that are out of proportion with the others? If so, point to the segment for additional information, and click the instance below the chart to drill down and investigate further.

Check the Advisors from Databases with the Highest Wait Time resource. Messages are automatically displayed in descending order by time stamp. You can sort the messages by severity, for example, only displaying Critical warnings. Point to the message for more information. Click the message to open DPA for further analysis.

In the Greatest Upward Wait Time Trends resource, look for line segments that show extreme upward trends. Point to the line segment for more information, and click the instance below the chart to drill down and investigate further.

The Advisors resource displays query issues that may not be urgent, but could become a problem later.

The (All) Database Instances resource displays the list of database instances, with items that have critical issues or warnings on top.

  • Click a database instance to see the Database Instance Details page. There you can see statistics from DPA, advisors, response time, the Mini-AppStack resource, and more.
  • Click an application instance to see the DB Performance tab in the Application Details view. There you can see the same resources from the corresponding Database Instance Details page.