SolarWinds DPA review
February 07, 2020
SolarWinds DPA review
Score 8 out of 10
Overall Satisfaction with SolarWinds Database Performance Analyzer
The SolarWinds DPA module is used mainly to monitor our MSSQL instances for performance. We had lots of issues related to DB performance and we were not sure about the root cause before implementing DPA. Now, we are getting proactive alerts when there is a deviation from the performance baseline configured in the tool and we are very happy with it.
- Saved lots of man hours from troubleshooting application slowness issue.
- Licensing model is a bit costly.
We had an issue where the application performance very slow. After troubleshooting and looking at DPA analytics we identified that SQL query was running slow and after tuning it the issue got resolved. This tool also helped us to create a performance base line and as soon as the query response time varies from the base line we get a proactive alert.
This definitely helped us. Like I mentioned previously, whenever developers write any SQL queries it needs to be tested in Dev environment. When it was pushed in prod, there were issues with slow performance. Table Tuning Advisors helped us in these scenarios, giving us a better idea and recommendations to run the tuning against a specific table in our DB.
- SolarWinds Network Device Monitor
- SolarWinds IP Address Manager
- SolarWinds Server & Application Monitor
- SolarWinds Network Bandwidth Analyzer
Solarwind is our enterprise monitoring tool and it is a simple turn-key solution when it comes to monitoring our Network devices, bandwidth utilization, server health monitoring, and application performance monitoring.
This is like a one stop shop where you can look at server health along with database performance monitoring analytics.
Best suited in a three-tiered environment where there is a web application, middleware, and a DB in the backend. Not suited in stand-alone DB environment like backend DB for a static website. DPA is also very well suited when troubleshooting the application performance related issue. It gives a clear picture of the issue.