DPA Pros and Cons
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.
When root cause performance hits through the resources tool, we then correlate that to the queries that were blocking or had waits. It is very useful to have specific times and details to find underlying issues. Then we can use the query help tool that offers suggestions to tune the queries that may help avoid this in the future.
Yes, we use this on a regular basis to tune queries and add indexes based on the Tuning advisor. It will help us see bad query design and provide a better overall experience to our end users. The goal here is to have all green, but there are many developers that write 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