TrustRadius
Great for general monitoring
https://www.trustradius.com/database-performance-monitoringSolarWinds Database Performance AnalyzerUnspecified8.3146101
Emmanuel Bradley profile photo
January 29, 2019

Great for general monitoring

Score 8 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with Solarwinds Database Performance Analyzer

Solarwinds Database Performance Analyzer is being used to monitor for issues with our SQL Servers by our organization. We use it to provide a baseline and display opportunities for improvement. The tuning feature helps us find bottlenecks and provide index suggestions. Our software development department uses the tool to show how the code has affected database performance. The network operations department monitors the data to find areas that may need upgraded hardware or configuration changes.
  • Displaying baselines helps to show management how a change has affected performance positively or negatively.
  • The tuning feature is helpful in showing areas that could be improved with an index or code updates.
  • Wait statistics information is very helpful to diagnose database bottlenecks.
  • Naming the hash takes more steps then it did in the past.
  • It would be nice if there was a way to group the wait statistics by procedure.
  • I search feature would be helpful.
  • The tuning suggestions reduced wait statistics by 80% when a new procedure was introduced without proper indexing.
  • Code has been reverted thanks to the data provided by SolarWinds Database Performance Analyzer.
A new procedure was introduced to make things more efficient. After it was deployed, the performance got worse. Solarwinds Database Performance Analyzer showed that a new index was needed and it would improve performance. After utilizing the advice, we realized the efficiencies with the new procedure.
The index suggestions have been helpful. When new procedures have been introduced, the Table Tuning Advisors has made significant improvements.
The integration with the other Solarwinds products was the main reason for my selection and the easy setup.
Solarwinds Database Performance Analyzer is well suited for general monitoring. If you are interested in overall trends and issues that have a significant affect on performance, then this tool works well. It is less appropriate for deep dives into specific issues. When trying to monitor new changes, the impact must be big enough to display a difference in the charts.