SolarWinds Database Performanc Analyzer - DPA Saves The Day!
Updated February 04, 2022
SolarWinds Database Performanc Analyzer - DPA Saves The Day!
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with SolarWinds Database Performance Analyzer
The tools you decide to use in your environment are only as good as the effort put in to make it a valuable asset to your organization. We run a Computer Aided Dispatch application that looks like a wagon wheel with interfaces. The application interfaces communicate to a database instance running in a cluster. Database Performance Analyzer has allowed our organization to fine-tune the database to the extent that we now know exactly when the database may be experiencing issues. The issues before used to be queries and users (machines). The database is running so efficiently now, we drill down to the machine that is causing the issue. It is generally a user that has kicked off a query that they should be running against the reporting server, not the live database. DPA is an amazing tool. I have a dashboard of off the "current" 10-minute slice in time. I can tell by a visual look if something is not right.
- Great Visual Display from Console - at a glance you can tell if there are issues
- Drill down on a single query to get recommendations on tuning the statement
- Automated Notifications, which can be customized / modified
- Live view on Storage I/O
- Resource Monitor is a plus - CPU Utilization - Instance and OS
- Recently addressed - protect the supply chain
- I can't keep up with all the improvements to tell you the truth ... Database Performance Analyzer is Awesome
- Demo Database Performance Analyzer - you will not be let down
- Join THWACK so you get the most out of your product. Great forum to get answers from colleges that may be experiencing the same issue!
- When we started, my database administrator was quite defensive. Database Performance Analyzer does not lie, we had many issues in our environment. The database would lock every morning at 3 AM when a purge job was running. Over time and analysis from the tools, we mitigated the locks on the database. We found out that there were 3 jobs running that choked performance. When we staggered the jobs, there was absolutely no impact on the users during the purge job.
- Database Performance Analyzer is like having another full-time employee on your staff, but it works 24X7 365 days a year! It is worth every penny for the purchase and maintenance. We have become proactive rather than reactive. My boss was running a couple of queries against the database. The 10-minute interval went from a cumulative 60 seconds of wait time per 10 minutes to over 1100 minutes of wait time in a 10-minute interval. Because of the monitor on the wall, we took action, drilled down to the machine, and immediately identified that it was our administration causing the database to potentially affect the end-users. I picked up the phone and told my boss that their computer was having an impact on the database. They quickly stopped their process and the database statistics quickly went back to normal. This has happened a couple of times.
- I have to admit, we lost our first database administrator. Database Performance Analyzer in your environment when properly managed can also point out a weakness in your staff. Failing to use the tools will result in termination!!!! I can't help lazy!
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