Stop buying hardware to improve your SQL server performance. Try DPA first!
November 19, 2019

Stop buying hardware to improve your SQL server performance. Try DPA first!

Dave Cheng | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with SolarWinds Database Performance Analyzer

Discovering data performance issues. Creating an index based on the suggestions by DPA. It can be accessed by all developers to review their query or performance-related issues.
  • Suggest indexes.
  • Indicate the wait time for all processes, so you rank the issues and fix them by priority.
  • You can send URL/ links to other to show them the exact point of problem. Easy for collaboration.
  • Bookmark of problem, so we can revisit the issue and compare it before and after the changes.
  • More details on deadlocks/blocking, etc.
  • Notification, kind of monitoring, if wait time exceeds some threshold.. or review the wait time of specific bookmarks or issues.
  • Very positive, we'd never be able to find out all the bad queries without it. Saved $ on upgrading hardware/resources on our SQL server.
  • We reduced wait time from > 24 hrs a day to a few hours a day.
  • No need to put more memory and faster SAN/RAID.
Interface, presentation, wait time...
We are more concerned with improving query performance than hardware/resource usage.
We may have navigation issues ... The back button is not very consistent on all pages. Sometimes we have to go back to the home page and start over on the server again.

Some queries, which only run very rare, but require a lot of waiting time whenever they do run (all queries that take longer than 60secs).