Overall Satisfaction with SolarWinds Database Performance Analyzer
I am the sole user of DPA and use it to monitor our two primary Oracle SE production databases running on VM. I use it to monitor resource usage, blocks, waits and make good use of the tuning advisor. The databases are hybrid OLT/warehouse with automatic data loads happening 24x7 and heavy reporting processes during business hours. DPA helps me balance performance between these.
- The tuning advisor quickly guides me to where the biggest performance issues are.
- There's a lot of built-in "help," definitions and possible actions to take.
- Alerts and trending information are very helpful.
- I have to frequently and repeatedly click the "Dismiss" button on banner messages that appear at the top of the screen. They're just annoying.
- We are a small IT shop. I have been the DBA for many years and am now both IT Manager and Senior DBA. I'm also a database application developer. DPA helps me to be an efficient DBA by alerting me to problems.