DPA - an esy to use and invaluable tool for a DBA or a software engineer professional.
January 25, 2019
DPA - an esy to use and invaluable tool for a DBA or a software engineer professional.
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Solarwinds Database Performance Analyzer
We are actively monitoring our production and staging environment for any potential negative impact of new deployments or a performance impact due to a dramatic data growth.
- No agent required on a server, which allows us to easily switch a monitoring target.
- Integration with a VM Hosting software, so a correct decision could be made on sudden resource utilization spikes.
- Capturing a live execution plan for further analysis.
- Historical monitoring data is available for an extended time period.
- Increase a query name file size, so the names could be more meaningful and allow for distinguishing different versions of the same query easier.
- Would be nice to see captured parameters for a query, when the usual execution plan was changed.
- On the statistical/historical site: highlight rarely used indexes.
- No negative impact so far.
- The tool helped to minimize downtime of high-performance utilization periods. Basically, our team starts looking into a potentially high impact issue before our customers even complain about any slowdown or unavailability of our service.
- SolarWinds Database Performance Analyzer has been especially useful when our customers start using a certain application feature in a way it was not designed for. For example, when there is a sudden change in a table usage: like unusual search parameters in a dynamic query involving some columns developers did not have indexes for. Or when customers use a note field as a way of communication making what was basically considered a static value, all of a sudden volatile.
- Both of these cases had a negative performance impact, which we were able to spot quickly with the help of DPA.