Awesome Tool for SQL Performance Tuning
Updated March 23, 2022
Awesome Tool for SQL Performance Tuning
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with SolarWinds Database Performance Analyzer
It is used by the database team to monitor and tune database performance in both SQL Server and Azure Databases. Slow databases, timeouts on websites and in services and applications, can frequently be caused by the data layer, and this is the best tool I've ever used for troubleshooting that.
- Tells you which statements in which stored procedures need work or are catastrophic (if that applies).
- Helps you focus attention on what really needs work, very efficiently.
- The UI gets clunky if you have lots of servers to monitor.
- It doesn't really rank problems across multiple servers.
- Not my current employer, but a previous one. We had a deployment of a large amount of code, including numerous database changes. The next day, everything that depended on that database server was down and the server was slammed to 100% CPU, RAM, and I/O. It would have been very difficult to identify exactly what was wrong, but it took only seconds to pull up Database Performance Analyzer and find the exact problem, and then less than a minute to patch the exact proc that had a problem. The whole company was locked out of business-critical sites and tools, and it could have taken hours to analyze the issue by means like traces, DMVs, etc. Instead, it took almost no time at all.
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