My DPA-review
June 07, 2019
My DPA-review
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.
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.
Pros
- 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.
Cons
- 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.
Comments
Please log in to join the conversation