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 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.