Solarwinds DPA - a DBA's MVP!
November 03, 2020
Solarwinds DPA - a DBA's MVP!
Overall Satisfaction with SolarWinds Database Performance Analyzer
SolarWinds Database Performance Analyzer is being used by IT in our organization. It allows us to have a better window into what the SQL servers are doing, especially with regards to applications that are using these SQL servers. It allows us to root cause problems and to find problems before they become bigger problems.
- Insight into query wait times
- Ability to view Disk IO
- Historical trending of wait times
- Dated UI
- Development servers are not free
- Dashboard visualization of stats requires Solarwinds Performance Monitor (Included with Orion)
- Was able to identify issues that we were able to take to one of our partners and improve the system for all users.
- Identified an issue with storage that was also impacting other users, speeding the route to solving the problem.
- Saves countless hours vs trying to pull these stats out of SQL server by hand. Being able to quickly find the source of the issue we are experiencing is invaluable.
We were having an issue where our check-in system was causing slowdown on SQL server. We were able to root cause the issue to some individual queries that were being generated by Entity Framework and work with the developer to rework the EF code to generate queries that were much more performant. This resulted in a significant decrease in the amount of CPU wait time we were experiencing and prevented us from needing to increase our server sizes to the next CPU tier.
Unfortunately we are not using this add-on, however it looks like it would provide great information.
Do you think SolarWinds Database Performance Analyzer delivers good value for the price?
Yes
Are you happy with SolarWinds Database Performance Analyzer's feature set?
Yes
Did SolarWinds Database Performance Analyzer live up to sales and marketing promises?
Yes
Did implementation of SolarWinds Database Performance Analyzer go as expected?
Yes
Would you buy SolarWinds Database Performance Analyzer again?
Yes