One of a kind
July 21, 2017
One of a kind
Score 10 out of 10
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.
- 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 SQL Diagnostic Manager
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.