Best Database Performance Tool
September 26, 2019
Best Database Performance Tool
Score 10 out of 10
Vetted Review
Verified User
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.
I'm used to Oracle Enterprise Manager and it is one of best for Oracle Enterprise Database.