SolarWinds Database Performance Analyzer Reviews

The primary use cases involve identifying database performance issues, such as long-running queries, wait times, deadlocks, and other read-and-write performance-related issues.

Long-running queries are particularly common, and customers find the tool useful for pinpointing such issues.

DPA has been helpful in providing recommendations to improve DB performance. The Table tuning advisories, causes for long-running queries, reasons for wait-times & deadlocks have helped tune the databases to give optimal performance.

We use SolarWinds Database Performance Analyzer for performance monitoring, tuning, and troubleshooting performance issues. It's mainly related to performance and the database community. Database administrators handle queries and system impacts.

The most valuable feature of SolarWinds Database Performance Analyzer is anomaly detection. It alerts you when things outside the norm are happening, and the feature that analyzes your indexes informs you if you have wide or overlapping indexes. It also helps identify SQL query bottlenecks, letting you know if something is taking longer than usual if a query plan has changed, and if you need to update statistics.

In terms of usage, it is straightforward to use, learn and understand. The patching process is smooth and explains each feature, including links to external resources for further reading. 

We use SolarWinds Database Performance Analyzer as a monitoring service for customers, particularly in the banking industry. The solution is part of the service we provide for our customers.

What I like most about SolarWinds Database Performance Analyzer is that it's a powerful solution that lets me advise customers about performance, and it also gives a lot of supporting information.

When something pops up, the solution helps us define the right area to find whatever solution we need.

SolarWinds Database Performance Analyzer helped us locate the performance issues quickly.

We use the tool for sharing and monitoring Microsoft SQL server databases.

The platform solves and prevents delays in receiving answers from databases. We can view several factors and compare queries. We can monitor potential problems for delays from hardware resources as well. We can investigate and tell where the problem is or where the problem could be in the future.

I use the solution to monitor database and manual activity and to generate reports. It is also a monitoring tool that we use for a little bit of monitoring.

SolarWinds Database Performance Analyzer's most valuable features include the notification of consuming the SQL queries, collecting data, and notifying about managing space and tables. The solution also gives some information or details regarding decision taking.

It was installed at a previous company I worked for, and they used it extensively there. It was cross-platform, so it was more than just SQL Server. It could work with SQL Server, Postgres and do all of the system metrics, such as RAM consumption, IO, network traffic, etc. It was a more in-depth package, but it was also rather expensive if I remember it correctly.

In my current company, I'm a new principal DBA. They hired me a week and a half ago, and I'm evaluating solutions to possibly purchase.

In terms of deployment, it has both on-prem and cloud deployments.

Monitoring is most valuable, and being able to know that there is an issue or problem and I need to go look is also valuable. So, monitoring and learning are the most important features.

Our customers' main use cases revolve around database monitoring. While many existing tools can handle basic monitoring tasks, more complex scenarios arise in enterprises. In these cases, customers need to identify bottlenecks and optimize performance. This is where a database performance tool like SolarWinds Database Performance Analyzer comes into play.

In IT, problems often occur in areas such as applications, web interfaces, or databases. The tool allows users to easily determine the root cause of these issues, whether they stem from the network layer, database layer, or elsewhere.

According to our clients, one of the standout features of SolarWinds Database Performance Analyzer is its advanced anomaly detection capabilities. While the tool may not heavily emphasize AI or ML, its advanced analytics and machine learning functionalities monitor extremely well.