One of a kind
Stephen Swan | TrustRadius Reviewer
July 21, 2017

One of a kind

Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Solarwinds Database Performance Analyzer for SQL Server

I have been looking to implement Solarwinds DPA for some time. It has been the only tool that can find performance issues in SQL code based upon waits. It is well worth the cost for that level of troubleshooting. By combining wait performance with historical execution plans, I can find what impact coding changes are making in the environment.
  • Wait based performance analysis
  • Historical execution plan comparison
  • Integration with other Solarwinds products
  • Minor pain points create difficulties in historical tracking.
  • We found significant performance gains even when just running the trial version.
  • We were able to verify that remaining issues were no longer caused by the coding.
Idera looks like they are headed to a similar end product. However, their product is not as mature. Solarwinds Database Performance Monitor is an acquisition of an already mature product upon which they added value by integrating it with their extensive software base and their amazing community. I haven't found any other products that do wait based sql analysis.

Solarwinds DPA is well suited to a DBA looking to improve performance over time. It allows tracking and alerting of queries. It makes finding pain points easy. This tool would not be good for a beginner DBA as it requires looking at execution plans and deciding where the problem has occurred.

SolarWinds Database Performance Analyzer Feature Ratings