A must have for critical SQL workloads
May 21, 2019

A must have for critical SQL workloads

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

Overall Satisfaction with SolarWinds Database Performance Analyzer

We use SW DPA to monitor the most critical database servers in the company. It provides an interesting slicing and dicing of performance metrics which enables us to use to plan and react to the servers' needs.
  • Very easy to deploy with a negligible performance overhead.
  • Excellent perspective on overall performance metrics.
  • Good alerting system for performance or events.
  • API based alerting.
  • Provides a good way to measure KPIs.
  • Gives an excellent view of the top or most expensive transactions, which has allowed us to identify and address them to cut processing or IO costs.
DPA simply provides another angle over the performance of the server, plus it is very quiet and has little overhead. I also like how historical performance data is stored, and although it does not really let you decide how it is aggregated, it is good enough.
I'd use it in any critical database server. Better yet, I would deploy it across the board to allow consistency on the management and handling of KPIs and alerts.