Database Administrator
January 25, 2019
Database Administrator
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.