Solarwinds DPA gives your non-DBAs the ability to look inside and diagnose database problems!
November 20, 2019
Solarwinds DPA gives your non-DBAs the ability to look inside and diagnose database problems!
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with SolarWinds Database Performance Analyzer
We use Solarwinds Database Performance Analyser across several teams in and around the IT department. It's used to pinpoint issues with databases or SQL statements, generally on production databases. While Solarwinds Database Performance Analyser won't tell you anything that a real live DBA wouldn't be able to find out, it does allow non-DBAs like myself to get an initial problem diagnosis quite quickly and suggest to the relevant teams where they should be looking to resolve the problem.
- Pinpoints potential issues with databases.
- Suggests remediation for these problems.
- Allows you to narrow down to particular points in time where the problems were observed.
- It does take a while to gather enough data to suggest problems and fixes. Generally speaking, while you'll get some data back in an hour or two, you want at least 2 days of monitoring to get the best results.
- Licensing is a bit restrictive.
- Switching licenses between monitored nodes is a bit annoying.
- Faster incident resolution time.
- Better-performing production databases during business-critical periods.
- Freeing up some of the time of my company's DBAs.
Solarwinds DPA came with a 30-day trial. We used that to evaluate the product, and when a P1 incident occurred with no DBA available we installed another 30-day trial. Its performance was good enough that we bought it that day!
We didn't try any other similar product before making this decision, SolarWinds Database Performance Analyzer was enough.
We didn't try any other similar product before making this decision, SolarWinds Database Performance Analyzer was enough.