SolarWinds Database Performance Analyzer

• Maintains historical SQL execution data, enabling forensic analysis
• Has the ability to slice and dice the data so that you can drill down to the execution of a single SQL statement being executed by a stored procedure
• Alerts to when the consumption pattern changes
• Shows historical average run times against the current, illustrating problems when they arise
• Provides tuning advice based on best practices

Read full review

• Alerts seem to be lacking in DPA compared to competitor's tools. They can be setup but are not quite as easy or as helpful as some other tools I have used.
• Grooming/pruning the repository database isn't very easy. We don't manage a lot of instances but our repo DB has grown pretty significantly.
• At times when I am drilled-down to a chart, it can be difficult to navigate around from that point to another time range/query/metric.

Read full review

• I cannot provide quantitative data, but can give you some real positive impact example .
• We had several points in the Internet banking applications which do not work as well as desired. Using DPA we identified the heaviest SQL queries and initiate a change request to the vendor. After implementing the received changes we are able to reduce response time by an order of magnitude.

Read full review