Life saver!
July 17, 2019

Life saver!

Mohamed Shameer | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with SolarWinds Database Performance Analyzer

DPA is used to monitor the performance of Oracle and MSQL databases. We added a highly critical system in DPA, and DPA can suggest performance enhancement based on findings over the period, like missing indexes and statistics. Also, during ad-hoc performance issues, this helps to identify the current performance, because of easy access like running a session, blocking, and querying a program that is running.
  • Index recommendation.
  • Tuning advisor.
  • Wait events.
  • Always-on monitoring.
  • Positive: we can address critical system issues promptly.
  • Improvement: we need more proactive monitoring alerts.
We used Toad SQL Tuning advisor. Compared to Toad, DPA is very comprehensive.
It's an easy tool to know performance bottlenecks, though the DBA is not from a performance expert background.