1. Home
  2. Database Performance Monitoring Tools
  3. SolarWinds Database Performance Analyzer Reviews
  4. User Review of SolarWinds Database Performance Analyzer
Great tool for a DBA
June 02, 2019

Great tool for a DBA

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

Overall Satisfaction with SolarWinds Database Performance Analyzer

DPA is primarily being used as a monitoring tool for our main production Oracle database. It helps to pinpoint problems or potential problems without effort. It replaces different Oracle monitoring tools and operating system resource monitoring tools (these tools are still used later in the troubleshooting process). It is also being used as an SQL tuning advisor.
  • Shows the database status in a single page.
  • Enables simple drilling into different database problem areas (CPU, ram, disks, sessions, etc.).
  • Regularly finds top queries that can be improved.
  • It would be nice if it could work with Oracle's SQL Tuning Advisor.
  • In some cases, DPA reduced the need for an expensive external Oracle performance expert.
Oracle EM is very useful, but it takes more time to find the root cause of a problem. DPA aggregates its findings in a very compact way, and an experienced DBA can see what is going on very quickly. We prefer to use both products in parallel.
I first used this product as a demo version on a not well-optimized database. In two weeks of monitoring the database, SolarWinds DPA found several issues that we didn't notice before. It really helped us, as we would not have been able to find all that stuff in such a short time.