DPA: The Advance DBA Tool
Updated July 17, 2020

DPA: The Advance DBA Tool

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

Overall Satisfaction with SolarWinds Database Performance Analyzer

Our SQL server performance monitoring is done by using DPA SolarWinds. It's used in our department only.
  • Details query capture with the plan and resource utilization.
  • DPA backend is an SQL server that you can control by performing some operations from the backend like change in retention, etc.
  • Supports latest SQL features like AG.
  • Report features are very good
  • License management. DPA is not able to sync licenses and needs you to manually reconcile every time.
  • Better monitoring and proactive action on the basis of data collected helped to reduce outages and performance issues.
  • AG monitor give HADR monitoring
In multiple performances issues logical reads , execution count and execution plan helps in tuning queries and comparing results after tuning. Before and after query performance details on same graph is very usey
Yes it is. When working on problematic queries and possible indexes and tuning steps then comparing them with possible troubleshooting given in performance tab really helps in leading right direction
  • SolarWinds Database Performance Analyzer
No
Well suited as an SQL server execution plan analyzer. Also, provides advice on the tunning part.

Alerting and reporting is also good features.