Database Performance Analyzer - Subscription (Linux)
SolarWinds | 2024.3Linux/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.
Incredibly helps with troubleshooting deadlocks and performance bottlenecks
What do you like best about the product?
Performance charts & reports to monitor server activity
Performance trending via main page
Bottlenecks
Blocking and locking
Deadlocks analysis and charts, deadlock details and trending
Error Log alerting
Failover Alerting
Performance trending via main page
Bottlenecks
Blocking and locking
Deadlocks analysis and charts, deadlock details and trending
Error Log alerting
Failover Alerting
What do you dislike about the product?
The query executions plans are not perfectly aligned and not named the same as the source queries under the performance tab which makes it a bit hard to track.
What problems is the product solving and how is that benefiting you?
Quicker performance overview of multiple environments.
Automatic performance
Automatic performance
Recommendations to others considering the product:
Download trial and try it
- Leave a Comment |
- Mark review as helpful
Would love to use it
What do you like best about the product?
it's a handy tool that will provide additional details on your performance problems which seem to usually turn out to be poorly written sql queries.
What do you dislike about the product?
we are not fond of the cost which makes it hard for us to justify use.
What problems is the product solving and how is that benefiting you?
we would realize a number of potential problems however the cost is too much for us.
Recommendations to others considering the product:
if your organization uses just a few dbs, this may not be for you. on the other hand if you are heavy in db usage and are looking for a tool, this is a great one.
DPA Usefull
What do you like best about the product?
Allows monitoring in real time of DB performance, and flags potential problems.
What do you dislike about the product?
Interface is a little klugy, but otherwise works well.
What problems is the product solving and how is that benefiting you?
Monitor and Optimize Database performance.
Recommendations to others considering the product:
Take a look. It's well worth the price and has helped us solve problems quickly.
Production Database Administrator
What do you like best about the product?
performance dashboard that gives a health summary of all the monitored database instances. Alerts can be customized and be used to alert for critical events that are logged in the SQL Server Error log. The ability to replay SQL Server database activity.
What do you dislike about the product?
Difficult to read the SQL Agent job failure and identify the actual job that failed.
What problems is the product solving and how is that benefiting you?
Being more proactive to SQL Server performance issues.
Recommendations to others considering the product:
DPA has it all. One tool that can monitor and alert all your SQL Server estate. You can also use it replay events that occur on your servers while you are sleep, it gives you all the events on your servers at at any point in time.
DPA is a pretty great tool
What do you like best about the product?
The best thing I've used it for was looking for root blockers and monitoring deadlocks but just from the features that I looked at while in the trial period it can do so much more. It was easy to use and the setup didn't take much time. I know that a lot of time can be put in on it but that is something else I liked about DPA. If you are willing to spend the time and develop it, it could be a one stop shop
What do you dislike about the product?
There wasn't much that I didn't like, there were times went the program seemed slow however that could have been due to the limitations on the database I was trying it on
What problems is the product solving and how is that benefiting you?
We were having issues with deadlocks happening during the middle of the day and DPA helped to quickly identify where they were coming from and who was causing it. (It was someone running 52 different reports in Orion for hardware monitors at the same time.) The benefits to me seem to be endless plus if given the opportunity within my current company I would like to see about getting it implemented
Recommendations to others considering the product:
It's a great tool for analyzing your database with. I would highly recommend it.
Tested in a POC environment
What do you like best about the product?
Adding DB to the stack to find performance issues.
What do you dislike about the product?
Systems team did not find the interface user friendly. They had no experience with SolarWinds.
What problems is the product solving and how is that benefiting you?
We were able to diagnose and issue with our SolarWinds NPM database and reconfigured the hardware setup.
Recommendations to others considering the product:
Good product that requires more diligent training of staff.
Productivity gains from quick troubleshooting.
What do you like best about the product?
We purchased Confio Ignite (now DPA) as it was called back, hoping to alleviate the time taken when performance issues occurred. Due to budget constraints, we have only one SQL Server DBA which was borderline OK as far as workloads go. However, we would fall behind whenever performance issues popped up or when troubleshooting needed to take place. DPA has worked wonders for our DBA and enables him to rapidly pinpoint where the performance issue is with a SQL Server database. We have also started to use DPA to provide alerts when things are not 100% OK in our SQL Server environment.
What do you dislike about the product?
The graphs showing top SQL statements and top waits, etc. are difficult to interpret because the colors used in the bar graphs are shades of the same color. It is often difficult to distinguish between the shades to determine which queries are the top offenders when the shades of red or green or blue are so close together. Note that this is not the case when you log in to look at details. However, the high level charts in emails are difficult to make out. I feel I should not have to log in to be able to make out the details - I am busy enough as it is.
What problems is the product solving and how is that benefiting you?
1. I get quick resolution to performance issues that used to take a lot longer to troubleshoot.
2. I get alerts in advance of something bad about to happen. We do not have to wait for application users to alert us to issues.
3. We have started to use DPA for our Oracle standard edition as it works so well with SQL Server. Although we have Oracle Enterprise Manager for our Oracle Enterprise databases, this does not cover monitoring Oracle Standard Edition databases.
2. I get alerts in advance of something bad about to happen. We do not have to wait for application users to alert us to issues.
3. We have started to use DPA for our Oracle standard edition as it works so well with SQL Server. Although we have Oracle Enterprise Manager for our Oracle Enterprise databases, this does not cover monitoring Oracle Standard Edition databases.
Recommendations to others considering the product:
There are a lot of features in DPA that make it worthwhile in itself. Try the free trail to get a feel for it. Additionally, SolarWinds has built an ecosystem around it. We run SQL Server on VMware and having the ability to monitor the VM on which SQL Server is running is very useful for a DBA (the VMware module adds VM stats to DPA - it is a separately purchasable module and not part of DPA). It lets the DBA independently monitor and verify the performance and state of the VM w/o having to bother the system administrator. This lets the DBA determine whether or not the host VM is having resource issues, etc.
DPA review
What do you like best about the product?
User interface working method and knowledge base
What do you dislike about the product?
Didn't understand perstack and DPA relationship
What problems is the product solving and how is that benefiting you?
I am not using but studied about the status
Recommendations to others considering the product:
Go for this database analysis it will be very helpful
Easy to use Database performance analysis tool
What do you like best about the product?
Everything is broken down with time based stacked graphs
What do you dislike about the product?
The expense if you have a lot of databases
What problems is the product solving and how is that benefiting you?
Quickly find out where the problem is.
Recommendations to others considering the product:
The price gets bigger if you have many databases but it's one of the best tools to quickly isolate where the problems are in your database with wait times. Easy to find the query where all the time is being wasted.
User friendly and simple
What do you like best about the product?
easy information presentation. Very user friendly UI. Doesn't lag. Liked the drag and drop feature. Easy to go through the charts.
What do you dislike about the product?
the best tool used so far. This was my first time using a DPA so hard to say if it was missing something.
What problems is the product solving and how is that benefiting you?
To monitor metrics of entire environment.
showing 161 - 170