I am ineffective without DPA
March 22, 2019

I am ineffective without DPA

Tim Powers | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with SolarWinds Database Performance Analyzer

It is used mostly by developers to identify bottlenecks but also by server admins to identify config or load issues. It is limited to use within the IT dept.
  • I have used it to demonstrate disk issues to server admins by showing them the drastic increase in DB Commit times which turned out to be a failed NIC.
  • I routinely use it to identify blocking sessions to verify ETL job issues.
  • I use the waits and the top SQL to monitor system performance issues.
  • I would like to have some visibility into the alert log in DPA.
  • I would like to have tablespace/datafiles information regarding space and items contained in them.
  • DPA saves me about 20 hours a month.
The DB Artisan and OEM feature set both have some overlap with DPA. But there a lot of features unique to each and therefore a great compliment to DPA.
It is really great at showing bottlenecks but it isn't going to give you a remedy for something like a high DB Commit time.