DPA Pros and Cons
Updated July 17, 2020
DPA Pros and Cons
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with SolarWinds Database Performance Analyzer
We use this product to diagnose and maintain the good performance of SQL Servers. We find degradation or lag, and it also helps issues with queries to be addressed.
- Query Analyzer
- HA Status
- DAG HA Analyzer
- Custom Time Windows for history
- Provides good data to help us speed up queries.
Using SolarWinds Database Performance Analyzer
4 - We have a development team that uses this product for information and refinement of our applications. Also, the management likes to see the overview to make sure we are falling into the thresholds of what we use. The systems administrators use this to manage resources and all the servers needed to optimally use our products.
2 - The development team and systems administration team supports the product. There are updates and settings that have to be managed. We also use the product for alerts and that system has had tweaks to maintain a level of information that is useful. The management and systems admins need different information relayed to them, so we use this system in different ways to suit the needs of the dept.
- Alerting for Critical Guidelines
- Information of resources and performance
- Tracking changes and history
- Information for AG and its setup
- Viability of the servers that it maintains
- Alert configurations to do many things outside the norm
- We are waiting for new features for AG and its DAG resources
- Manipulate the servers and procedures based on the recommendations of DPA