SolarWinds DPA Review
March 15, 2019

SolarWinds DPA Review

Paul LaPosta | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with SolarWinds Database Performance Analyzer

We use DPA to monitor our AWS SQL RDS Instance for performance. We use it to troubleshoot congestion and tune queries. We also use DPA on our development and staging SQL DBs to analyze performance before new code is released into production.

Over the years DPA has helped us to resolve a lot of issues with blocking, locking, and excessive CPU utilization. We have done this both in real-time, during outages, and as part of our development pipeline.

Pros

  • Real-time viewing into wait statistics, blocking and locking.
  • Valuable query and table tuning advice.
  • Historical tracking of wait times.

Cons

  • The drill down usability is cumbersome.
  • It's sometimes difficult to navigate exactly to where you want to be.
  • Could use more information around parameters.
  • It has helped us resolve issues faster than we could without the tool, often times allowing us to resolve issues before our end users notice.
SolarWinds DPA is a crucial part of our stability and performance monitoring strategy. At a glance, you can see what's going on - any blocking and/or excessive waits. It also alerts you in real-time based upon thresholds you define.

Comments

More Reviews of SolarWinds Database Performance Analyzer