SolarWinds Database Performance Analyzer Review
Updated August 14, 2020

SolarWinds Database Performance Analyzer Review

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

Overall Satisfaction with SolarWinds Database Performance Analyzer

We use it at the data warehousing and analytics group to monitor the load and set up alerts on the data warehouse server. We have set up alerts on long-running queries, blocking other queries, deadlocks, instance availability, unused indexes, etc. Some of them are very useful, but the deadlocks alert can be improved to show what queries were in the deadlock, so we can improve our solution.
  • We have set up alerts on long-running queries, blocking other queries, deadlocks, instance availability, unused indexes, etc.
  • The status summary is useful to see the load on the server.
  • Deadlocks alert can be improved to show what queries were in the deadlock, so we can improve our solution.
  • Deadlocks alert can be improved to show what queries were in the deadlock, so we can improve our solution.
  • We never got to setup https using the documentation provided by solar winds. We still keep getting https error when we access our DPA site.
  • A better technical customer service would help.
  • It helps us monitor our server which is very useful.
It helps us balance the load and find queries that need optimization.
Some help from customer service will be useful to set this up.
  • SolarWinds Database Performance Analyzer
We do not use any other product yet.
We selected SolarWinds Database Performance Analyzer to be able to monitor our database server.
Direct access to most experience support engineers - fast response and follow up from SolarWinds engineers
We have not used this feature yet.
We encountered some errors when upgrading DPA to a newer version. We posted our issues on the SolarWinds forum for dQP and got a response with in a couple days and the problem was solved.
It is good to set up alerts on the database server. some of the alerts described in previous answers can be improved. Help on setup can be improved. As described earlier, we still do not have our DPA site set up with the security certificate and customer service did not help much.

SolarWinds Database Performance Analyzer Support

We get access to the forum where SolarWinds representatives answer our questions and the representatives do a good job answering our questions, in time.
We did our DPA upgrade ourselves but the support helped us resolve our problems.

SolarWinds Database Performance Analyzer Smart Start

pretty good
Direct interaction with Smart Start technician
fast issue resolution
assistance with upgrade helped complete it faster

ROI

I don’t know how much time was saved
3 or more points
  • Price
  • Product Features
  • Product Usability
  • Product Reputation
  • Prior Experience with the Product
  • Vendor Reputation
  • Third-party Reviews
yes, Query tuning advice from DPA has improved our application performance

Using SolarWinds Database Performance Analyzer

8 - Database developers and architect
  • Query performance advice
  • long running query alerts
  • query blocking alerts
  • deadlock alerts
  • improve application performance
  • improve server availability
  • monitor data server performance and availability

Evaluating SolarWinds Database Performance Analyzer and Competitors

We evaluated Redgate and Found solarwinds to be better

SolarWinds Database Performance Analyzer Implementation

Change management was a minor issue with the implementation
  • enabling secure website posed some issues. Installation was smooth

Configuring SolarWinds Database Performance Analyzer

We can configure alerts for what we want to monitor, Example Failed agent jobs, deadlocks, service down, long running queries etc.
yes. I have configured deadlock monitoring, service down, long running queries, blocking queries, agent job failures, query tuning advice. They are very useful.
No - we have not done any customization to the interface
Some - we have added small pieces of custom code - we have added custom code to monitor long running queries, blocking queries.
deadlock monitoring, service down, long running queries, blocking queries, agent job failures, query tuning advice
We have not used SolarWinds Orion yet.

SolarWinds Database Performance Analyzer Support

very good. Respond within a day
ProsCons
Quick Resolution
Good followup
Knowledgeable team
Problems get solved
Kept well informed
No escalation required
Immediate help available
Support understands my problem
Support cares about my success
Quick Initial Response
None
I was not able to enable secure website. The support helped me with that

Using SolarWinds Database Performance Analyzer

very good
ProsCons
Like to use
Relatively simple
Easy to use
Technical support not required
Well integrated
Consistent
Quick to learn
Convenient
Feel confident using
Familiar
None
  • monitoring memory usage
  • monitoring processor usage
  • query advice
  • certain reports are difficult to understand

SolarWinds Database Performance Analyzer Reliability

Integrating SolarWinds Database Performance Analyzer

  • SQL server
We only monitor our SQL server database. pretty easy

Relationship with SolarWinds

support for the product to be included
vendor is pretty good, very responsive

Upgrading SolarWinds Database Performance Analyzer

Yes - yes, it went pretty smooth
  • new features like deadlock alerts,
  • new reports
  • deadlock alert
  • new usage reports
Not sure - we already have professional version.