Why DPA can save your firm money, help developers, and ease DBA job.
Craig Solinski | TrustRadius Reviewer
February 15, 2019

Why DPA can save your firm money, help developers, and ease DBA job.

Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SolarWinds Database Performance Analyzer

We run six separate DPA servers covering three different database software vendors. Coverage includes TEST Databases where developers can instantly observe metrics from their most recent changes. Production coverage, of course, is crucial to rapidly identify SQL and VM performance matters and observe changes based on the volume of transactions. This tool is the first place hundreds of developers, admins, and managers use to check app performance.
  • Top N SQL queries.
  • Outstanding UI for rapid examination and drill down to detail data.
  • Intuitive UI design - better than any other product in its category.
  • Enabled us to immediately shift DB related performance matters first to developers so that our DBA's can focus on more important matters.
  • Allow alerts to SMS (text message).
  • Total requests to DBA team dropped several hundred percent after the rollout of the tool. Since the tool works so well, developers/managers/admins are requested to FIRST analyze by themselves, and only after their inability to identify or resolve the problem, promote to the DBA team.
  • Ease of implementation and upgrades combined with self serve monitoring, automated reporting, and alerts have all reduced valuable DBA team effort and time, allowing them to focus on more important tasks.
Insights provided by the tool rapidly and continually allow developers to code and modify increasing transaction throughput and reducing transaction time. Personally, I've identified and validated transactions in question. Also, I use this tool to compare new releases of application software against past performance. The top N SQL list is an excellent metric to first investigate after any application upgrade.
Any Tuning advise is worth investigation. Past experience implementing suggestions from Tuning Advisors has significantly increased transnational throughput.
SolarWinds is simpler to implement and simpler for users to glean meaningful data. Much less expensive. DPA focuses on VM and DB SQL thruput while Datadog and Dynatrace are full-fledged deep dive application monitors that trace transaction execution across multiple servers and deep dive into the application code itself. Often times, all of this is NOT required and FIRST using DPA saves a lot of time.
Extremely reliable and bug-free software that can be used over hundreds of databases of various types when run from multiple servers. When monitoring virtual machines, it also reports the VM metrics. Best in class for ease of use and net result value to developer/manager/admin.