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.
A greater insight into database performance.
What do you like best about the product?
DPA offers a great overall view of your live databases and can immediately draw your attention to potential problems. It saves you a lot of time in the way it can troubleshoot a lot of problems for you or bring to your attention problems that could lead to downtime etc. It’s easy to set up and gives you peace of mind, especially when managing multiple databases. It has helped us solve ongoing problems by relaying historical information and bringing certain trends to our attention. Highly recommended.
What do you dislike about the product?
As good as DPA is, it can get quite costly especially if there is a need for growth. Some reporting and the in built search could be better.
What problems is the product solving and how is that benefiting you?
It is a massive time saver and helps us rectify problems quicker, resulting in less downtime and helps us be more productive. It also helps remove potential problems before they turn into one.
Recommendations to others considering the product:
If cost isn’t too much of a worry and you’re looking for insight into your database health then consider DPA. You can download a full trial of the product that can help you see what the product can do for you.
- Leave a Comment |
- Mark review as helpful
Making DB management so much easier!
What do you like best about the product?
DBA by solarwinds is another excellent module for DB management and monitoring. If you have felt like you're blind to DB performance issues, DB problems or anything else then this product will change the way you work. It will help you find problems much faster and even prevent potential downtime, by bring things to your attention before they cause problems. The varied views help you have a quick oversight of all your DB without going in and out of various windows. The historical information is another by win for DBA, allowing to monitor query performance etc.
What do you dislike about the product?
DBA lacks search capability at the moment and this would be something that would improve it, if it was implemented. It would also be nice if it was closer integrated with the rest of the solarwinds platforms, as it feels like a separate product entirely at times, though this isn't that big a deal.
What problems is the product solving and how is that benefiting you?
It's hugely increased workflow and productivity and prevented definite downtime on more than one occasion. It's also helped us keep our DB more streamlined to prevent slow down for end users.
Recommendations to others considering the product:
If you feel like you're always blind to DB problems and are not sure where to start then DBA could be the way to go. Check out a trial first to see it in action and i'm sure you'll start to see what it has to offer and how it can improve your day to day workload.
DPA makes life so much easier in the Database world.
What do you like best about the product?
The UI is a great way of drawing your attention to the potential or ongoing problems with your DB. You can see at a glance or an even more in depth view if you so wish. It has helped us build trends and resolve problems by simply allowing the program to monitor our DB. If you're looking for a program to monitor and even predict potential issues with you DB this is it.
What do you dislike about the product?
It doesn't integrate into NPM as well as other modules and doesn't offer some of the detailed views and charts that NPM generally offers. Other than that it's great.
What problems is the product solving and how is that benefiting you?
It prevents downtime or even future downtime, by allowing us to nip potential issues in the bud before they happen. Also a much easier way of seeing the DB etc.
Recommendations to others considering the product:
If you are looking for software to monitor and bring DB problems to your attention then this is it. It's extremely helpful, not too hard to set up and will give you peace of mind once you're live.
Solarwinds DPA
What do you like best about the product?
I like the monitoring of access and commit times. The amount of I/O tracking is amazing. It helps to quickly drill down to the root cause, which helps in a more expedient determination of our issues. I have also noticed that we get a more heads-up on issues that have yet to be reported to us.
What do you dislike about the product?
I have not found anything so far. I really like this feature all around. The main page is a little overwhelming at first for users, but once they learn where everything is located, the main page is perfect.
What problems is the product solving and how is that benefiting you?
Our biggest problem was tracking down where our issues were with latency and CPU usage. Also, the delay in reporting from end user issues and the database could be delay several minutes.
Great Product to keep your Databases in check
What do you like best about the product?
Ease of use and great dashboard for display of performance charts.
This was easy to setup and get running.
Lots of useful information on the solar winds Thwack users form.
Graphical chats and UI work well and make it easy for us to spot an issue.
This was easy to setup and get running.
Lots of useful information on the solar winds Thwack users form.
Graphical chats and UI work well and make it easy for us to spot an issue.
What do you dislike about the product?
The price is a little high but the it does have a lot of features for the price !
What problems is the product solving and how is that benefiting you?
We looked at this tool to prevent outages caused by poor database performance. We can proactively monitor everything to ensure the sites are up, functional and running efficiently.
Recommendations to others considering the product:
Ensure it meets all requirements> it is easy to setup and integrate into an existing solar winds environment.
Got a problem with your database performance, and the DBA blames the network, install DPA!
What do you like best about the product?
The ability to drill down on queries and to download reports with graphs for management.
What do you dislike about the product?
It is still difficult to explain to management that it is NOT the network. The graphs have helped substantially; I wish that there were a "view for dummies" !!
What problems is the product solving and how is that benefiting you?
I have proved that it is NOT the network. We now have regular quarterly database maintenance windows!
Recommendations to others considering the product:
This product really helps you find out what is going on inside the database, it is very granular and has assisted our operation tremendously in cutting down wait times.
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.
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
showing 51 - 60