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.
Must Have tool for Any SQL DBA
What do you like best about the product?
Ability to see current activities from multiple aspect/view is best thing for me.
When there is a an issue with any Server and need to quickly narrow down to the right place of root cause this is a tool allows me to focus on right places and remove all sorts of noise from data.
Tagging and Annotation is another great feature.
Ability to see the historical details/plan/ is very helpful while working on Query performance.
When there is a an issue with any Server and need to quickly narrow down to the right place of root cause this is a tool allows me to focus on right places and remove all sorts of noise from data.
Tagging and Annotation is another great feature.
Ability to see the historical details/plan/ is very helpful while working on Query performance.
What do you dislike about the product?
1) I can not search the specific text on any of the sub screen when drill down to session/sql/machine etc... tabs.
2) there is only one way to search the SQL by actual text is "SQL TEXT" and that is not complete. it would be good to have some place we can search specific sql I am looking for.
3) any adhoc sql/queries are not grouped to gather (like procedures) and hence its historical details can not be viewed. it will be good to have some way of connecting those adhoc sqls using same plan and being able to generate execution history.
4) on the same adhoc plan tab, for any given plan we have to drill down each sql manually one by one. it would be god to have some kind of summary popup/tool-tip when we hover over the plan in DPA.
2) there is only one way to search the SQL by actual text is "SQL TEXT" and that is not complete. it would be good to have some place we can search specific sql I am looking for.
3) any adhoc sql/queries are not grouped to gather (like procedures) and hence its historical details can not be viewed. it will be good to have some way of connecting those adhoc sqls using same plan and being able to generate execution history.
4) on the same adhoc plan tab, for any given plan we have to drill down each sql manually one by one. it would be god to have some kind of summary popup/tool-tip when we hover over the plan in DPA.
What problems is the product solving and how is that benefiting you?
It is a go to tool for me in my current work place for finding/analyzing/solving any type of SQL DB issues.
it removes the waste from screen speed up the process that increases the over all cycle time for resolving any DB issue.
it removes the waste from screen speed up the process that increases the over all cycle time for resolving any DB issue.
- Leave a Comment |
- Mark review as helpful
DPA - Precise Performance Measurement
What do you like best about the product?
It's very simple to deploy and starts collecting data as soon as we link it to a database. I like that we can drill down to one second interval. Plus it retains the data for 5 years. One of the greatest advantage is that it as minimal impact on the monitored SQL server.
There is the resource adviser which gives us an idea of where the issue probably is and where to start the investigation.
We use this in addition to SolarWinds Orion SAM - which as AppInsight for SQL template. This gives us additional metrics we can look for to see if it's more of a server issue (memory, CPU, storage, etc).
During the first usage we were immediately able to see the high wait times and that it was attributed to the NETWORK_IO. This is something we can investigate and is in our control.
There is the resource adviser which gives us an idea of where the issue probably is and where to start the investigation.
We use this in addition to SolarWinds Orion SAM - which as AppInsight for SQL template. This gives us additional metrics we can look for to see if it's more of a server issue (memory, CPU, storage, etc).
During the first usage we were immediately able to see the high wait times and that it was attributed to the NETWORK_IO. This is something we can investigate and is in our control.
What do you dislike about the product?
Would be nice to customize the views, similar to Orion. So different users have a customized view. The user administration is pretty basic and isn't built for multi tenancy. But this tool is primarily for the DBAs and I have not seen anyone else use it.
What problems is the product solving and how is that benefiting you?
Excessive wait times and what's causing it. There are things which can't control, such as badly written queries; however there are things within our control like server memory, CPU allocation, IO bandwidth, storage latency, etc. These are the factors we can concentrate on to improve the overall response time of the database and reduce waits as much as possible.
Recommendations to others considering the product:
DPA is very detailed in it's analysis - it's really meant for DBAs. I have seen some system admin use it - but not that effectively.
Easy install opens deep doors into your db performance
What do you like best about the product?
DPA is very easy to install and takes little time. The demo was up and running within an hour after spinning up the host VM. This gave our DBA team a change to try it out before we made a purchase. Other tools are a full project to get running and leave agents and tracks all over the environment. DPA does not, if you uninstall there is nothing left behind excect the account used to monitor the databases. These accounts can be quickly deleted and there is no trace of DPA left behind. This is important for beta testing. We were able to test in our Prod env and got a real look at what we were buying. The ease of use makes everyone in the NOC a value adding DB performance monitoring guru. SW products are mostly very user friendly, DPA also fits this description. The data provided is top shelf from engineer, to dev, to IT executive. Built in reports give you great data from day 1 and a little customizing makes you look like a DB Performance Monitoring Master. Low cost solution that gives you a ton of value.
What do you dislike about the product?
Nothing to note as of yet. Since DPA is a newer product from SW I am not sure how support will be if we ever do need to engage. I have to assume it will be similar to the other products in the suite..
What problems is the product solving and how is that benefiting you?
Viewing db. issues/health is a breeze now. As a lifetime IT Ops person we tend to learn that app slowness is always the network first, then firewall, then IIS/web server, and possibly the app but never the database. DPA rules out the guessing with a few clicks. Prove its the DB or not the DB instantly. Historical trending is spot on. ROI is outstanding as we have been empowered to better allocate IT funds where needed. DBA team has embraced the tool and made our deployment a huge success. In the end DPA has been a significant win for our IT teams as well as business partners. And its cheap (when compared to other similar products). Also great integration to the Solar Winds platform if you are already there. DPA has been the easiest monitoring tool deployment in my 20 plus year career.
Recommendations to others considering the product:
Do the demo and see what you think. Install is very quick and simple so its an hour of your time and then turn the DBA team lose. The cost is much lower than most other tools on the market so ROI is not a factor. Install is easy to remove if you don't like the product after the beta and no agents or other tracks left after removal.
DPA personal review
What do you like best about the product?
I personally love the real time aspect to troubleshooting. It is often something other products can deflect. It fully integrates into other Solarwinds products like NPM. Cross vendor support is also a great benefit, SQL, Oracle, MySQl, SAP, and cloud offerings.
The live charts are worth their weight in gold. being able to see and then go back in time to check before the issue happened is wonderful and one of its best features. I have used other products that over look this and the fact you can alter the granularity yourself is great.
The live charts are worth their weight in gold. being able to see and then go back in time to check before the issue happened is wonderful and one of its best features. I have used other products that over look this and the fact you can alter the granularity yourself is great.
What do you dislike about the product?
some of the features are needed to get the most out of the other solarwinds products. you often feel like you have to buy the set to get the most befit.The cost of the product can quickly rise. The start price is great but in reality its vastly higher when you factor in a larger environment. I know its cheaper then other solutions however when you factor in you really need other modules to make sure you're getting most out of it (SAM) it really does rack up the cost.
What problems is the product solving and how is that benefiting you?
bottlenecks. It comes with a lot of of the box and is able to detect issues I wasn't aware of. It makes you seem like a Database performance specialist even with limited knowledge. We have seen a few speed issues just from the real time performance charts.
Recommendations to others considering the product:
personally I would use this in conjunction to owning the other solar winds products. NPM and SAM are a must
DPA a good solution to monitor performance of your Databases.
What do you like best about the product?
SQL query tuning advice.
Identifies database problems in realtime .
DPA can monitor database instances that you manage running on physical or virtual servers. It can also monitor Amazon RDS instances hosted in the Amazon Elastic Compute Cloud (EC2).
Identifies database problems in realtime .
DPA can monitor database instances that you manage running on physical or virtual servers. It can also monitor Amazon RDS instances hosted in the Amazon Elastic Compute Cloud (EC2).
What do you dislike about the product?
Overall a very good but as all products have some flaws, it too has one which is sometimes experiences slowness.
What problems is the product solving and how is that benefiting you?
Identifies Blocking sessions and deadlock for a query.
Generates an alert for a query taking longer to execute.
Gives an advice for better query execution.
Minimum system requirements.
Generates an alert for a query taking longer to execute.
Gives an advice for better query execution.
Minimum system requirements.
Recommendations to others considering the product:
My recommendation to others considering DPA is that they should install a 15 days evaluation version of DPA, to checkout if this product meets their requirements.
Best product for Database and SQL query performance monitoring
What do you like best about the product?
It does Database and SQL query tuning.
Can identify database problems in short time.
Has wide range of database engines to choose from and that too in single installation.
Can identify database problems in short time.
Has wide range of database engines to choose from and that too in single installation.
What do you dislike about the product?
Nothing much as much.
It solves my issue of supporting wide range of database engines on one platorm.
It solves my issue of supporting wide range of database engines on one platorm.
What problems is the product solving and how is that benefiting you?
Monitors Oracle, SQL Server, MySQL.
Has quick response-time analysis to problems.
Can integrated with server and application monitoring(SAM).
Has quick response-time analysis to problems.
Can integrated with server and application monitoring(SAM).
Recommendations to others considering the product:
Best in class for Database and SQL query performance monitoring and tuning.
A very useful database monitoring tool which eases troubleshooting very much
What do you like best about the product?
The best thing about DPA is it identifies the performance issue with in seconds and by focusing on wait stats identifying the root cause is very easy. We can see instantaneously if blocking was occurring at any specific time and what were the root blockers. The good thing is it gets down to minutes and even seconds of time in terms of granularity. It also allows to set up various custom alerts which is very beneficial
What do you dislike about the product?
The thing I found to be wanting in solarwinds DPA is the graphs for various metrics can capture time - value pair of only one metric. I can't capture multiple instances of a metric (for example - multiple replication distribution agents latency values ) from with in DPA
What problems is the product solving and how is that benefiting you?
We mainly use DPA for performance monitoring and optimization of our SQL databases. It allows benefits like blocking identification, capturing resource bottlenecks like CPU, memory etc and we set up numerous customized alerts in solarwinds DPA.
Recommendations to others considering the product:
The tool is recommended because its very easy to use and rich in feature set
Solarwinds Database Performace Analyzer
What do you like best about the product?
I like the interface. The Status Summary provides the information that is most important at a glance.
What do you dislike about the product?
When drilling down into an issue you can sometimes get lost in the navigation.
What problems is the product solving and how is that benefiting you?
We have been able to identify issues with long running queries and implement fixes.
Great Tool for Performance Troubleshooting
What do you like best about the product?
Very clean interface that makes identifying problem queries easy to spot
What do you dislike about the product?
Integration with Orion platform is half baked.
What problems is the product solving and how is that benefiting you?
Performance slowdowns and optimization.
Solarwinds DPA Review
What do you like best about the product?
You are able to select different types of data to be analyzed and you are able to see the results easily.
What do you dislike about the product?
It seemed a bit slow to update the data, but that may be because it was a demo product.
What problems is the product solving and how is that benefiting you?
We are trying to analyze our VMs that store our database and the efficiency of them.
Recommendations to others considering the product:
Try the demo to see if it will suit your needs
showing 101 - 110