DPA - A simple and well-built SQL Tool to find Issues within your Databases!
May 02, 2019

DPA - A simple and well-built SQL Tool to find Issues within your Databases!

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with SolarWinds Database Performance Analyzer

The DPA product has and continually assists in finding performance issues in stored procedures and queries that are occurring against the database. We recently had a significant issue with performance and being able to go back minute-by-minute is fantastic and allowed us to diagnose the issue much faster.
  • Simple and intuitive to navigate.
  • Provides Top queries and makes good recommendations that are accurate.
  • Good reporting use for C-Level colleagues who don't understand the techincal side of Databases.
  • Having a search bar to search for particular SQL code would be useful, Especically when attempting to find a new SQL Hash name on a fixed stored proc
  • The ROI has been the best selling point to us in the past 12 months due to unforseen performance issues where we were able to quickly diagnose the exact stored procedure to feedback to our Software Provider.
SolarWinds DPA Product has a fantastic small footprint and allows for any System Administrator or Database Administrator to easily find Queries that are taking excessive resources or time, which in turn can affect the product performance. Being able to retrospectively go back has proved to us many times that you don't have to wait up and run SQL Trace at 1AM to find out what query is causing issues!