Database Performance Analyzer - Subscription (Linux)
SolarWinds | 2023.4.300Linux/Unix, Amazon Linux 2 - 64-bit Amazon Machine Image (AMI)
Reviews from AWS Marketplace
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
DPA to the rescue
What do you like best about the product?
Capability to overlay DB performance statistics with hardware metrics KPIs
What do you dislike about the product?
It does not yet provide full integration with Orion platform, so switching between main Orion console and DPA console is required for deep troubleshooting
What problems is the product solving and how is that benefiting you?
Slow response times for paying customers due to database wait times. Changed application designed to improve end user & customer experience
Recommendations to others considering the product:
This may not provide as deep insight into Oracle DB as more native tools, but it provides the capability of overlaying DB stats with hardware and OS stats. Same goes for SQL monitoring and our DBAs are very pleased with this tool
- Leave a Comment |
- Mark review as helpful
DPA really made my job of sorting through database to know the speed and health easy.
What do you like best about the product?
I like how DPA leverage all my S3 databases
What do you dislike about the product?
Sincerely there's no good software without a disadvantage. But I have not seen anything you should improove on except the pricing. That might be because of the country I'm in.
What problems is the product solving and how is that benefiting you?
It's very tasky to statcally connect to every database everytime I want to manage, DPA helps in managing all of my databases simultaneously.
Recommendations to others considering the product:
it is the best solution for anyone with dificulty in managing database expecially those just learning.
Database Performance Analyzer review
What do you like best about the product?
The software is easy to upgrade and administer.
SolarWinds provides good support.
The main dashboard shows which database instances are experiencing the greatest wait times. It also shows those with the greatest upward wait times. There is a status summary with counts that are color coded for quickly finding issues. Below that, is a listing of all the instances with a color coded status across multiple categories. From there, you can start drilling down into specific instances and see top SQL statements, Waits, Programs, Users, etc. It is very easy to see trends or if it was just an abnormality. You can see across days or drill down into specific hours. It also provides advisors and quick resources (e.g. wait descriptions).
SolarWinds provides good support.
The main dashboard shows which database instances are experiencing the greatest wait times. It also shows those with the greatest upward wait times. There is a status summary with counts that are color coded for quickly finding issues. Below that, is a listing of all the instances with a color coded status across multiple categories. From there, you can start drilling down into specific instances and see top SQL statements, Waits, Programs, Users, etc. It is very easy to see trends or if it was just an abnormality. You can see across days or drill down into specific hours. It also provides advisors and quick resources (e.g. wait descriptions).
What do you dislike about the product?
The cost for licensing Oracle RAC instances is expensive. Each instance costs $3,495 at list price which adds up quickly.
What problems is the product solving and how is that benefiting you?
When new queries are introduced into the environment and are detrimental, we quickly see when it started and the frequency that it occurs.
We also use this to quickly focus on the top queries causing issues instead of isolated incidents.
We also use this to quickly focus on the top queries causing issues instead of isolated incidents.
Recommendations to others considering the product:
Should be at the top of your list.
Excellent insight into what your Databases are really doing
What do you like best about the product?
The simple, yet very powerful interface makes DPA (Database Performance Analyzer) a product that is easy to implement and use. The power of the product gives insight that would otherwise only be available through hours of trial and error testing and processing. SQl can be complex to diagnose, but with DPA that time and effort is greatly reduced.
What do you dislike about the product?
While the product is very complete it can't make users actually pay attention. Our DBAs have access, but don't rely on the product as much as they should. But then this is a shortcoming of pretty much anything.
What problems is the product solving and how is that benefiting you?
We had some slow performing SQL databases and DPA helped us identify underlying issues that couldn't be solved just be adding more CPU or memory
Recommendations to others considering the product:
Download the free trial and you'll find it easy to install configure and use.
Database administration and performance troubleshooter
What do you like best about the product?
Quick visual of performance bottlenecks and the drill down within every screen is a great feature in trying to get to the bottom of fixing an error troubleshooting query performance.
What do you dislike about the product?
If we can get more tips on database related messages as it seems the recommendations are sometimes very general in nature
What problems is the product solving and how is that benefiting you?
DPA has helped me get to the bottom of a long standing performance issue with a client ERP on SQL server and we have now stabilized the performance. DPA showed me where and which time the major bottlenecks where coming from. Now we can move to tuning the queries with DPA.
Recommendations to others considering the product:
DPA is easy to install and very lightweight so no worries on the analyzed database or instance taking a performance hit.
An extremely helpful tool
What do you like best about the product?
I like the one stop analysis, this allows us to more efficiently manage our databases
What do you dislike about the product?
I don't have any complaints at this time
What problems is the product solving and how is that benefiting you?
ensuring efficient use and access to databases
Using Solarwinds Database Performance Analyzer we find the root cause of performance issues.
What do you like best about the product?
It is very easy to see the queries running on the database and how long each takes. With this, we can determine if we need to make the query more efficient or what other action is best such as reindexing.
What do you dislike about the product?
I have been sitting here racking my brain trying to think of a feature I would like to be added or a database it should support but I cannot think of anything I dislike about it.
What problems is the product solving and how is that benefiting you?
We have identified issues in indexing and queries in not only our in-house systems but in applications supplied by third parties. When on the phone with vendors they asked how we were able to find the issue and we told them about Solarwinds DPA.
Recommendations to others considering the product:
Do what we did. Download the trial version and see the tool for yourself.
Works very well for the situation we have
What do you like best about the product?
The fact we can monitor multiple things at the same time to make sure that we are running the best we can. I like the integration with other Solarwinds offerings
What do you dislike about the product?
Nothing that Im aware of for now. We seem to like it in the review stage. Seems like it will do exactly what we need it to.
What problems is the product solving and how is that benefiting you?
Making sure everything is running smoothly for managing information
Recommendations to others considering the product:
Make sure you know what you are doing :) Love the interface seems to work well
Another tool in a great suite of tools!
What do you like best about the product?
I appreciate how SolarWinds integrates all of their tools under one easy-to-use interface.
What do you dislike about the product?
I've only used the tool in trial mode as we're evaluating whether it is a fit for us. So far, it's a no brainer. No major hurdles to this point.
What problems is the product solving and how is that benefiting you?
Mostly we are hoping to use it for digging into problems that we can't easily identify root cause of. As we are small staffed, we don't have a fulltime DBA on site. This tool helps us system admins dig deeper into issues without having quite the in-depth knowledge of SQL as it points us in the right direction.
Sometimes the SQL is better than the original
What do you like best about the product?
I really liked the capability of monitoring the SQL performance of different queries
What do you dislike about the product?
If I had to pick a least favorite piece of the whole process, it would be installing the application in the first place, because no one ever likes that, even though the documentation was very well done.
What problems is the product solving and how is that benefiting you?
I was optimizing queries so that I could have the least amount of server impact
Recommendations to others considering the product:
Definitely download the trial and try running some of your more processor intensive queries and actions. See what the software can really do and see what it is the best at.
showing 91 - 100