My DPA-review
June 07, 2019

My DPA-review

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with SolarWinds Database Performance Analyzer

I am the only user of the department that uses SolarWids Database Performance Analyzer (DPA) almost every day. I use DPA for monitoring a single Oracle production database, and gets alerts when it does not perform or when it's unavailable to the users. The monitoring also pinpoints which SQL statements needs tuning, which I can correct before the problems get serious.

DPA makes it possible for me to be proactive. I find the DPA-GUI to be very user-friendly and easy to understand even without reading the manual.
  • SQL-tuning advice. It's easy to locate the most inefficient SQL-staements as they are all graded. You just click and drill-down to see both the SQL-statements and statistics. That info will most likely give you enough knowledge to solve the issue, for example by adding an extra index.
  • The monitoring of the database by setting up your own alerts in all kind of categories. For example, alerts when tablespaces are running full or when disk/CPU load are too high or if the server becomes unavailable.
  • The possibilty to browse the repository and see trends. You can see exactly when problems are starting and see if the changes you make has an effect in the time to come.
  • The license-management seems difficult to use, and I always find that I need to contact SolarWinds when upgrading server, etc.
  • DPA makes it easy to be proactive and react before a problem gets serious.
  • I don't have to check the state of the database as often, because I know that DPA will alert me in time (if you have made a proper alert-setup).
I have only used DPA, as that were the best to use when running Oracle Standard Edition.
DPA pinpoints quite well which SQLs could need tuning, and it shows which impact the bad SQL had on the database and which impact the correction has afterwards. The repository collects more and more knowledge of your database as times goes by which enables you to see trends over time. You can very easy customize all kinds of alerts and get alerted (for example, by email) if something serious happens with your database.