SQL Server Application DBA at a construction company with 1,001-5,000 employees
Mar 15, 2022
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.
Learn what your peers think about SolarWinds Database Performance Analyzer. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
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.
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.
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.
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 areas where it currently lags are in reporting and dashboarding. The reports and dashboards are somewhat static, and we cannot create custom dashboards for specific customer needs.
Learn what your peers think about SolarWinds Database Performance Analyzer. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
One area where the tool could improve is by adding support for additional databases. For instance, supporting newer databases like Couchbase or MongoDB would be beneficial.
