Best Database Performance Tool
September 26, 2019

Best Database Performance Tool

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SolarWinds Database Performance Analyzer

We use it to monitor and performance-tune some of our in-house developed applications. Some of these applications are tier-one applications.
  • Track historical performance.
  • Isolate the issue by providing a specific area of query impacting performance.
  • Can track which user is causing the issue.
  • Provides quick indexes where it makes sense.
  • Auto tuning - It doesn't have the ability to implement the changes like Oracle Enterprise Manager.
  • DPA free version is good but fully functional version should be allowed free for a limited number of instances to give users the ability to try functions without a need to make a purchase.
  • It definitely helps me pinpoint the issue quickly instead of waiting for log analysis. I can focus on the actual issue with confidence. I have used this tool several times to pinpoint locking issues and poor execution plans.
  • I have also used index suggestion. In one application, where only 100 concurrent sessions were freezing the server, it allows us to go to 450 without any change to the hardware, cost savings on hardware as well as SQL and Windows licensing.
  • SolarWinds ipMonitor
The network team uses IP monitor-to-monitor systems and network.
It is very appropriate in an environment where you have programmers making changes to an application. It may not work much for a canned application where the performance is already tuned.