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.
The integration with the other Solarwinds products was the main reason for my selection and the easy setup.