Database Performance Analyzer great product in the right situation

Pros

The indepth detail and knowledge you get from this product is amazing, more than a reporting tool, its full monitoring with drill down details of storage, applications and more.

Cons

There is No support for SAP HANA. We moved from a supported MS SQL database to HANA for SAP and it doesn't have mature support for HANA.

Use it to monitor and analyze our database perform.

Useful current or historical information on query (high wait / load / execute time).

Pros

Agent base software, easy to install and manage on either Physical or Virtual OS. Provide useful information on database performance (CPU, disk, query, wait time, and other status). Allow to setup any custom alerts and monitoring on MySQL or MSQL.

Cons

The agent itself could be sometimes consume some memory / threads / process if your database server is light on resources and critical on performance.

Simple and Straighforward

Go ahead to use it

Pros

The really nice thing about DPA is that I can send developers a login and link (you can create non-admin "read" accounts) and it's easy enough to use that they can visualize and understand things without having to jump into an user guide. the tool is simple to use and offers a viable freeware whose only basic limitation is a four window for history - this allows for one to test drive the software and see exactly what it can do.

Cons

It would be nice if there were a little more customization available on some of the detail screens, and when viewing all of the SQL for a time segment it would be nice if the information weren't presented as an image, which would allow you to search for a text string (that is currently embedded in the image. It will be good if the price is lower

DPA Good SQL tool

Solarwinds DPA has been a great asset to out toolset. While adhoc SQL can tell us a lot this tool helps to bring it all together in a single tool with great visual references. It also provides great history to review issues and performance impact and goals.

Pros

Ease of use and history

Cons

Don't really have any.

You don't have to be a DBA to benefit from using this!

Pros

We were able to use this product to identify issues with our database's performance that was initially thought to be caused by network issues. I'm not a DBA but I was able to easily navigate through the product and view snapshots of performance data during the time people were experiencing issues. Having the historical performance data was absolutely vital. As you know, the information about an issue occurring never arrives in real time! After drilling down (again, super easy) I was able to see that a few large queries were responsible for the slowness. It even provided advice on how to improve the queries. I was able to send that information to our DBA who could use it to make improvements.

Cons

I had a hard time coming up with a con for this since it really did exactly what I needed it to do. So I have to resort to this: it's not free.