TrustRadius: an HG Insights company

SolarWinds Database Performance Analyzer Reviews & Insights

Score5.5 out of 10

229 Reviews and Ratings

Community insights

TrustRadius Insights for SolarWinds Database Performance Analyzer are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

User-Friendly Interface: Users appreciate the SolarWinds Database Performance Analyzer for its straightforward and easy-to-understand interface. They find it intuitive and user-friendly, even for new users with minimal training.

Real-Time Analysis and Support: The tool's real-time analysis capabilities and support services are highly valued by users. They mention that it helps them promptly identify and resolve performance issues in SQL databases, such as errors, long-running queries, or system-blocking problems.

Wide Range of Supported Databases: Users find the extensive range of supported databases to be a valuable feature of the tool. It allows them to monitor and analyze the performance of multiple databases from one centralized interface.

SolarWinds Database Performance Analyzer Reviews

4 Reviews
Engineering

SolarWinds Database Performance Analyzer

Rating: 7 out of 10
Incentivized

Use Cases and Deployment Scope

We use this product across the whole organization for multiple applications.

Pros

  • Easy to use.
  • Flexible.
  • A good tool to analyze DB performance.

Cons

  • Needs a more alert setup
  • Needs 24/7 support.

Likelihood to Recommend

I feel that SolarWinds Database Performance Analyzer makes it easy to identify DB issues and helps us to resolve performance problems proactively. We implemented SolarWinds DPA on more than 450 servers in the last year, but sometimes we are facing an issue with data collection. Also, there is no 24/7 support, so it's very hard to reach the support team during the US night time.

DPA is a helpful monitoring and analytical tool

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

We use SolarWinds Database Performance Analyzer to predict the behavior of our campaigns and e-marketing. With SolarWinds Database Performance Analyzer, we can check the performance of our databases and how the behavior will be during high load works in the season and spikes that are associated with our day by day jobs.

Pros

  • Predict performance across all databases
  • Predict unexpected behavior
  • Make a correct forecast about how much memory and CPU could be needed for a particular job

Cons

  • The agent usually consumes a lot of memory
  • High cost, since it is charged per instance.
  • An efficient and intelligent search feature would be helpful.

Likelihood to Recommend

SolarWinds Database Performance Analyzer is a really good software for monitoring purposes. If your company is e-marketing related, this is a good tool since you can see the overall trends and issues that cause a significant effect on performance when campaigns are being sent. But it is not good enough for deep dives into specific issues related to Database.

DPA is A-OK

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

We use DPA to locate issues within our application communicating with SQL. We also look for any long running queries that can be tuned to be more efficient. It has helped us narrow down several issues in our application code.

Pros

  • Detailed information on SQL queries.
  • Good analysis of where problems are occurring.
  • The lookups are very quick.

Cons

  • The cost of this tool is pretty high, especially when using other SolarWinds products.
  • A more user-friendly UI would be helpful.

Likelihood to Recommend

If your app interfaces with SQL in any way, you should give DPA a try. It has been helpful in identifying several queries that needed tuning. It's also pointed us towards issues in our code that needed to be modified to run better.

A must have tool for any production dba

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

There are three ways we use DPA -
- Daily review by one of our team members to see anomalies.
- Drilling down while troubleshooting ongoing issues.
- Setting up reports to keep the hard record of a baseline.

Since DPA is a wait time oriented monitoring tool, it perfectly completes other homemade SQL scripts used to monitor and troubleshoot performance.

Pros

  • An easy way to get the status of the databases.
  • An easy way to drill down.
  • Ability to see at glance the current database health.

Cons

  • It's not very intuitive when "zoom in" "zoom out" needed while looking at performance. Eventually, you figure this out. But it would be better to see all events sharing the same timeline.
  • Some minor issues with web implementation that include auto login. Probably related to cookie handling.

Likelihood to Recommend

After working with a bunch of other solutions I admit the best advantage of DPA is a design around wait-events. That's exactly what others are always missing while providing a deep performance analysis. At the end of the day, the most important thing is how long database consumers have to wait for a particular transaction to be finished.
Vetted Review
SolarWinds Database Performance Analyzer
2 years of experience