Database Administrator
January 25, 2019

Database Administrator

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

Overall Satisfaction with Solarwinds Database Performance Analyzer

The SolarWinds Database Performance Analyzer (DPA) is primarily used to monitor the performance of critical databases in the environment. It has been very helpful in assisting the team in identifying performance bottlenecks and helping our DBAs to be proactive with potential performance issues before it reaches the end-users.
  • Query tuning advisor.
  • Historical performance data collection.
  • Providing query information along with its source system.
  • "Alerts" setup is not intuitive.
  • Lack of support for multi-domain AD/LDAP configuration.
  • No straight forward method to get plan handle number from plan hash value displayed in DPA.
  • Index tuning on frequently-used queries in critical database servers, which significantly reduces instance total wait-time.
  • Ability to quickly troubleshoot performance issues using wait-time data with RCA.
Well-suited scenarios: (1) Collecting historical performance data and monitoring system's health with a minimal overhead or performance impact. (2) When you have no existing DPA tool in the environment or are considering purchasing/switching to a different DPA tool.