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.