SolarWinds DPA - perfect for query performance analysis.
Updated July 19, 2020
SolarWinds DPA - perfect for query performance analysis.

Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with SolarWinds Database Performance Analyzer
DPA is currently used by our development and support team to monitor our core database to keep an eye on performance day to day to avoid any rogue queries or new application causing issues for our business as a whole. In the early days of our business platform it was used to refine our queries to provide a better user experience.
Pros
- Highlights abnormal query performance
- Provides historical base line
- Gives detailed insight and these days recommendations on how to improve performance
Cons
- Not be written in JAVA and run on Apache
- Upgrades are always a problem for us
- In the early days of our application this proved to give an invaluable insight to improve performance
- It has also helped prevent issues before users have reported them which is great
At the time of evaluation, this product was similar in terms of cost but DPA was far better to access query performance issues which were the most important aspect for us. Redgate at the time was heavier on resource monitoring which was less important at the time.
SolarWinds Database Performance Analyzer Support
SolarWinds Database Performance Analyzer Support
Pros | Cons |
---|---|
Quick Resolution Good followup Knowledgeable team Problems get solved No escalation required Immediate help available Support cares about my success Quick Initial Response | None |
No - Don't require it. DPA is hugely useful but not considered mission-critical so premium support would be wasteful.
As alluded to earlier I have had a number of issues during upgrading the software, despite following the guides for the process I had often been left with something not right, and on one occasion the service flat out refused to start. Troubleshooting guides didn't offer any solution so I contacted support. Within a short while I actually received a call from Solarwinds support to go over the problem, and following their clear given advice I was still not able to get the service started. The support engineer escalated the issue, whilst on the call, and almost immediately had someone available screen share to the server. They went thought the installation scripts and rather quickly found why the service wasn't starting, which they promptly resolved. I have to say to this day I think this was the most responsive, timely and impressive support call I have ever experienced.
I would like to close on the fact that this was a couple of years ago and more recently upgrading the software (at least on the last 2 occasions) has been problem-free for me.
I would like to close on the fact that this was a couple of years ago and more recently upgrading the software (at least on the last 2 occasions) has been problem-free for me.
Comments
Please log in to join the conversation