SolarWinds DPA saves the day every time
November 05, 2020

SolarWinds DPA saves the day every time

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

Overall Satisfaction with SolarWinds Database Performance Analyzer

We use SolarWinds Database Performance Analyzer to fine-tune SQL Server workloads and alert us to unexpected issues occurring on our database clusters. It helps us to see problems before they happen - long running queries or unexpected disk thrashing and to fix these problems before users become aware of a situation.
  • Analyzing query performance
  • Index recommendation
  • Wait time categorization and explanation
  • Navigation is generally good, but some items can be confusing to find again
  • Identified excessive blocking and allowed correction
  • Prevented need to upscale Amazon servers
  • Ensured that developers write efficient SQL code
We knew that we had an issue with disk performance and were intending to move to provisioned IOPS to resolve the problem using Amazon AWS. We used SolarWinds Database Performance Analyzer to understand the issues further and found that a series of extremely quick queries were running from a legacy process which ultimately performance millions of table scans per hour. By optimizing this process in just a few minutes, we were able to avoid the need to further scale our SQL environment. This type of issue would typically be invisible - quick queries don't stand out like a sore thumb, but they can have tremendous impact.
This is non-applicable to our environment.

Do you think SolarWinds Database Performance Analyzer delivers good value for the price?

Yes

Are you happy with SolarWinds Database Performance Analyzer's feature set?

Yes

Did SolarWinds Database Performance Analyzer live up to sales and marketing promises?

Yes

Did implementation of SolarWinds Database Performance Analyzer go as expected?

Yes

Would you buy SolarWinds Database Performance Analyzer again?

Yes

The one time I contacted support, they were easy to speak to and resolved my question quickly.
It's super simple to install, manage and you'll find yourself acting on insights within minutes of the installation.
The product works incredibly well when trying to understand blocking and overall performance issues. It produces minimal load on the database server and provides a wealth of information. After you use the product to assist with urgent performance issues, it then alerts you to trends on your database server that may require your attention. By review these trends and adding indexes or modifying query patterns, you can substantially improve the performance and reduce the resources needed to running your database server. The software does require someone that understands query performance and optimization -- by no means does it do all of the work for you - but it does offer suggestions that are typically viable and worthwhile.