Solarwinds from an application standpoint.
February 01, 2019

Solarwinds from an application standpoint.

Jason Brokaw | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with SolarWinds Database Performance Analyzer

It is primarily used by the Business Intelligence department and now and then by the IT department. Currently, we use it to monitor our database systems, most especially our EHR system. DPA allows me to monitor day to day operations, the health of the database systems, and any special issues that arise in our EHR vendor's code. As a BETA client for our EHR vendor, I've used it to monitor new code that may be having an increased impact on the database and use DPA's reports to start the conversation with the developers.
  • Real-time monitoring and notification of blocks and deadlocks on the database.
  • Real-time notification of outages, including overnight issues that may arise.
  • Ongoing monitoring, query by query, showing the impact of resources and utilization.
  • Navigation is not always intuitive. Sometimes I need to drill down into 10-minute layers just to access a piece of information that I would have preferred to find at the hour or day level.
  • Time has been a big bonus as it handles a lot of monitoring for me and requires me to spend less time staring at Profilers.
  • Vendor choices sometimes conflict with DPAs licensing model. We now have three applications that require their own instance of SQL. If it's not solo on that instance, the vendor will not support it. This then causes us to cringe at licensing another instance of DPA to monitor one application that was poorly developed.
It's freed up a lot of time for me and made me less reliant on running SQL Profiler for long periods of time to gather data to investigate an issue. Now I can just go look at the history and work my way forward figuring out where an issue originated and with whom.