SolarWinds Database Performance Analyzer Professional, Scientific, and Technical Services Reviews & Insights

Score5.6 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

18 Reviews

Professional, Scientific, and Technical ServicesLegal Services1Accounting1Information Technology & Services14Marketing & Advertising2

DPA is hell lot of a Business for Database world

Rating: 10 out of 10

Incentivized

December 23, 2020

Use Cases and Deployment Scope

We are using Solarwinds Database Performance Analyzer for few of our customers to help in monitoring their Database Environment which includes Microsoft SQL, Postgre SQL, Oracle etc. Solarwinds DPA is primarily used by Database Administrators, Application Engineers (Read Only) and Tools Administrators. There are few interaction with Key Management stakeholders for data analysis but its relatively less.

Likelihood to Recommend

Solarwinds Database Performance Analyzer is well suited in below Scenarios -
1. End to End Database Instance Monitoring.
2. Database in Clusters Monitoring such as Availability Group in MS SQL, CDB in Oracle etc
3. If you want detailed monitoring with historical analysis.
4. SQL Statement Deep Dive Analysis for WAIT Time reason, Blockers, Deadlocks etc

Solarwinds DPA is not well suited if you are looking for Detailed VM, OS monitoring where Database is installed.

Pros

Multi Vendor Databases Monitoring
Agentless Monitoring
Less Dependency on DB Admins
Less Resources consumption on target databases
API based integrations

Cons

Cloud Database Monitoring such as Google native SQL service
Modern (no SQL ) database monitoring
Dashboard Flexibility
Reporting Flexibility

Nikhil Kumar Sharma

Associate Consultant in Engineering at HCL Technologies (Information Technology & Services, 10,001+ employees)

Vetted Review

5 years of experience

View profile

SolarWinds DPA saves the day every time

Rating: 10 out of 10

Incentivized

November 5, 2020

Use Cases and Deployment Scope

We use SolarWinds Database Performance Analyzer to fine-tune SQL Server workloads and alert us to unexpected issues occurring on our database clusters. It helps us to see problems before they happen - long running queries or unexpected disk thrashing and to fix these problems before users become aware of a situation.

Likelihood to Recommend

The product works incredibly well when trying to understand blocking and overall performance issues. It produces minimal load on the database server and provides a wealth of information. After you use the product to assist with urgent performance issues, it then alerts you to trends on your database server that may require your attention. By review these trends and adding indexes or modifying query patterns, you can substantially improve the performance and reduce the resources needed to running your database server. The software does require someone that understands query performance and optimization -- by no means does it do all of the work for you - but it does offer suggestions that are typically viable and worthwhile.

Pros

Analyzing query performance
Index recommendation
Wait time categorization and explanation

Cons

Navigation is generally good, but some items can be confusing to find again

Verified User

Executive in Information Technology (Information Technology & Services company, 11-50 employees)

Vetted Review

10 years of experience

Top of Class Database Performance Monitoring and Tuning Advisor!

Rating: 9 out of 10

Incentivized

April 27, 2020

Use Cases and Deployment Scope

We use DPA for database monitoring across the enter enterprise, dev/QA and production. We connect it to Oracle, SQL and MySQL Database Servers. We use DPA as a single source of monitoring for database performance issues. The historical and real-time query monitoring allows us to troubleshoot and quickly identify the root cause of a poorly performing server.

Likelihood to Recommend

SolarWinds Database Performance Analyzer (DPA) is great for monitoring Oracle and SQL databases for performance anomalies. When a user calls and says "It's slow" we have one [place] to go to review the data, zero on the problematic query and take action to resolve. In addition to being a great troubleshooting tool DPA also provides query tuning advice based on captured long-term analysis to spot inefficient patterns.

Pros

Database performance monitoring.
Database performance root cause analysis.
Server performance monitoring.

Cons

Licensing Model can be expensive on a per-instance basis, consider a per-host-based option.
Limited ability to combine monitoring results for similar groups of servers.
Different license types for different types of servers (Oracle Enterprise vs Standard).

Verified User

Engineer in Information Technology (Information Technology & Services company, 201-500 employees)

Vetted Review

7 years of experience

Keep an eye on your databases using Solarwinds DPA

Rating: 10 out of 10

Incentivized

April 19, 2020

Use Cases and Deployment Scope

A database should be more optimized to run faster and efficiently. SolarWinds Database Performance Analyzer is one of the best applications which is used as a management and performance monitoring solution for any database. This software is straightforward to use and configure. And it is user-friendly. In our organization, we are using SolarWinds Database Performance Analyzer to manage database performance issues such as errors, long-running queries and more.

Pros

The interface of the SolarWinds Database Performance Analyzer is straightforward. And it is easy to understand also.
SolarWinds Database Performance Analyzer helps to immediately identify the performance problems of SQL Databases such as errors, long-running queries or issues that are blocking the system.
It provides real-time analysis and support. Also, it can review issues from a historical point of view.
Many databases are supported.

Cons

The cost of acquiring this software is bit expensive. But it's absolutely worth.
It takes considerable time to load.
The reporting feature should be improved.

Likelihood to Recommend

SolarWinds Database Performance Analyzer can smoothly work with different databases such as MS SQL Server, Oracle database and more. Also, it supports physical, virtual, cloud, etc.

Aruna Bandara

Associate Engineer in Information Technology at Axiata Digital Labs (Information Technology & Services, 501-1000 employees)

Vetted Review

1 year of experience

View profile

SolarWinds Database Performance Analyzer Review

Rating: 10 out of 10

Incentivized

March 17, 2020

Use Cases and Deployment Scope

Currently, our DBOps and SysOps teams use SolarWinds Database Performance Analyzer. Both teams use it to analyze our database clusters and individual databases.

Pros

Shows performance issues
Displays blocking

Cons

Likelihood to Recommend

SolarWinds Database Performance Analyzer is well suited for monitoring and providing information for our internal and customer databases.

Verified User

Engineer in Information Technology (Marketing & Advertising company, 501-1000 employees)

Vetted Review

6 years of experience

DPA Pros and Cons

Rating: 8 out of 10

Incentivized

January 24, 2020

Use Cases and Deployment Scope

We use this product to diagnose and maintain the good performance of SQL Servers. We find degradation or lag, and it also helps issues with queries to be addressed.

Likelihood to Recommend

Very good at query help and resource information. Not so good at DAG HA designs. We have a DAG setup and SolarWinds DPA can not even see the local HA if this is setup. That is kind of a bummer since we need the HA information and DAG is an older tech.

Pros

Query Analyzer
HA Status

Cons

DAG HA Analyzer
Custom Time Windows for history

Verified User

Team Lead in Information Technology (Information Technology & Services company, 11-50 employees)

Vetted Review

5 years of experience

Invaluable, Trusted Performance Diagnostics

Rating: 9 out of 10

Incentivized

December 4, 2019

Use Cases and Deployment Scope

DPA is an essential part of performance monitoring our hybrid Demand Management Solution for hosted customers, and select on-premise customers. Automation is essential considering the number of customers, the schema comprising approaching 3,000 tables and over 5,000 code artifacts. Daily summaries of the last 3 days of Top SQL resource consumers give us ongoing snapshots by which to spot trends and anomalies that DPA's functionality enables us to investigate to query and table level.

Pros

Automated Collection into a queryable repository - Hands-off, detailed collection assures us that the bulk of any performance issues are noted, so that their data can be presented on-demand in a readily consumable form. Drill-into features enable detailed analysis.
Performance Trend Analysis - Monthly top-consumers visualized in meaningful stacked-charts, with anomaly highlights and per-query, per-day detail enables hot-spot drill-down analysis.
Resource Utilization Warnings - Best-practice warning and critical measure applied to all facets, visualized in real-time are essential features that trigger troubleshooting.

Cons

Usability within the Trends and Current pages need improvement - Version 11 introduced a new Tuning feature, and changed the way one could quickly name a query and chose whether it would be of further interest, or is more infrastructure-oriented such that exclusion is warranted. Usability took a downward slide.
Resource Utilization has preset periods which, for longer durations, overly smooth charts. Custom periods are much needed via the UI, rather than repository-querying.
Storage analysis, similar to resource usage, needs custom periods and far greater ability to delineate between drives and files than v11 currently offers. (One rarely uses the Storage I/O tab)

Likelihood to Recommend

Having used DPA for a multi-tenant, single DB server, SaaS, solution, and currently monitoring over 30 productions and QA DB servers, on a server-per-customer basis, SaaS solution, both are entirely appropriate DPA targets. Wherever lower spend due to optimized DB performance is considered, DPA is one of the best tools to meet that kind of objective.

Verified User

Professional in Research & Development (Information Technology & Services company, 501-1000 employees)

Vetted Review

6 years of experience

Would be lost without it

Rating: 9 out of 10

Incentivized

November 24, 2019

Use Cases and Deployment Scope

Used to monitor production database performance and identify areas for tuning.

Pros

Allows instant identification of highest impact performance issues
Provides visibility of database load across the application
Easy to configure and use

Cons

It's a great product. I really can't identify any cons.

Likelihood to Recommend

It's useful for DBAs as well as application developers, by providing visibility of performance issues in an easy to understand graphical format. It then allows you to drill into the issue and identify how to resolve.

Verified User

C-Level Executive in Engineering (Information Technology & Services company, 11-50 employees)

Vetted Review

8 years of experience

Great alternative for Oracle Enterprise Manager

Rating: 8 out of 10

Incentivized

June 10, 2019

Use Cases and Deployment Scope

We're using SolarWinds Database Performance Analyzer on a daily basis for:

monitoring our Oracle RAC performance
searching for performance bottlenecks
analyzing historical data and trends
solving developers problems

It's our one and only database monitoring solution.

Pros

It's super helpful when hunting down problems with performance.
It's easy to install and configure.
It doesn't require crazy computation power or tons of memory.
DBA-friendly.

Cons

GUI/UI could be more modern.
Pricing: it's reasonable but not cheap.
Deep integration with AWS managed databases would be really nice.

Likelihood to Recommend

It's a great alternative to Oracle Enterprise Manager especially when you on a standard database license. If you're in a cloud environment like AWS your monitoring options are slightly limited. It would be great if SolarWinds could add some integrations with CloudWatch and native RDS, Aurora, etc. metrics to correlate database performance with "hardware" metrics.

Verified User

Professional in Information Technology (Information Technology and Services company, 1-10 employees)

Vetted Review

1 year of experience

Try it out if you want happy customers

Rating: 9 out of 10

Incentivized

June 7, 2019

Use Cases and Deployment Scope

We use it across our department to monitor our database landscape. We have different flavors of databases across our landscape, and SolarWinds for years has been an important part of the strategy for our monitoring solutions for the database tier across the landscape. It is very intuitive and quite easy to implement.

Pros

Immediate bottlenecks on the database tier.
Performance tuning.
Historical reports.

Cons

More details around the specific alerts which are raised on the console should be considered.
More information from a host layer monitoring could be handy as well.
A single layout for the report for all the different instances of DPA would be really handy. It is just tedious to go granular for all the instances across the landscape.

Likelihood to Recommend

Very intuitive and easy for operations organizations to ensure that any symptoms which could lead to performance concerns on the database tier can be easily identified and looked at.
To ensure these issues can be given highest priority as and when any performance bottlenecks arise, the simple layout provided with the tool is really effective.

Verified User

Engineer in Engineering (Information Technology and Services company, 10,001+ employees)

Vetted Review

3 years of experience

Loading Reviews List....

Invaluable, Trusted Performance Diagnostics

Rating: 9 out of 10

Incentivized

December 4, 2019

Use Cases and Deployment Scope

Pros

Automated Collection into a queryable repository - Hands-off, detailed collection assures us that the bulk of any performance issues are noted, so that their data can be presented on-demand in a readily consumable form. Drill-into features enable detailed analysis.
Performance Trend Analysis - Monthly top-consumers visualized in meaningful stacked-charts, with anomaly highlights and per-query, per-day detail enables hot-spot drill-down analysis.
Resource Utilization Warnings - Best-practice warning and critical measure applied to all facets, visualized in real-time are essential features that trigger troubleshooting.

Cons

Usability within the Trends and Current pages need improvement - Version 11 introduced a new Tuning feature, and changed the way one could quickly name a query and chose whether it would be of further interest, or is more infrastructure-oriented such that exclusion is warranted. Usability took a downward slide.
Resource Utilization has preset periods which, for longer durations, overly smooth charts. Custom periods are much needed via the UI, rather than repository-querying.
Storage analysis, similar to resource usage, needs custom periods and far greater ability to delineate between drives and files than v11 currently offers. (One rarely uses the Storage I/O tab)

Likelihood to Recommend

Verified User

Professional in Research & Development (Information Technology & Services company, 501-1000 employees)

Vetted Review

6 years of experience