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

5 Reviews

Small Businesses (1-50 employees)

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

Useful database monitoring tool

Rating: 8 out of 10

Incentivized

June 3, 2019

Use Cases and Deployment Scope

The primary purpose that we use Database Performance Analyzer for is to monitor database instances. We also use it for Query performance analysis. We also use it for performance analysis. For our application, we monitor primarily the index advisory/recommendations.

Pros

We use this software to identify real-time performance problems such as errors, long-running queries or problems that are blocking the system.
We use this software to review previous SQL Server queries/performance.
When there is an issue with any Server and I need to quickly narrow down to the right place of the root cause, this is a tool that allows me to focus on the right places and remove all sorts of noise from our data.

Cons

Cannot easily find a query using a "text search" without detailed knowledge of the underlying SQL database "repository" that is used to display the data in each product.
On the ad-hoc plan tab, for any given plan we have to drill down each SQL manually one by one. It would be goOd to have some kind of summary popup/tool-tip when we hover over the plan in DPA.

Likelihood to Recommend

Recognizes database issues continuously. You can see instantaneously if blocking was occurring at any specific time and what were the root blockers.

Verified User

Manager in Information Technology (Oil & Energy company, 11-50 employees)

Vetted Review

3 years of experience

DPA helps us with ongoing identification of slow running SQL code

Rating: 9 out of 10

Incentivized

April 19, 2019

Use Cases and Deployment Scope

We use it to monitor our complex solution that provides location and video feed for a fleet of connected vehicles. The solution is an extremely complex set of MSSQL Databases with constant data flow of around 5000 messages per minute. Each message required several different post-processing tasks that are developed as SPs Triggers and Jobs in the SQL server. We make a lot of changes to the solution constantly. Sometimes these can result in a massive slowdown speed in parsing of the incoming messages. We use the DPA to analyze the situation when this happens and to catch the piece of SQL code that is causing this to resolve real-time issues.

Pros

Quickly points out what is slowing down our SQL server
Provides daily statistics on most ran queries and their wait time
Operates flawlessly with no maintenance

Cons

Sometimes it cannot tell the SQL query text - I believe its when Entity Framework SQL is being ran
Email notification when a SQL statement starts "killing" the whole server
Full text search of specific SQL termS in all of the SQL code that it has captured

Likelihood to Recommend

Well suited to real-time analysis in our use case. Ill-suited to proactive monitoring / alerts (or maybe we just don't know how to set these up).

Brano Pajer

Solutions Architect in Research & Development at InfoSoft NI Ltd (Computer Software, 1-10 employees)

Vetted Review

1 year of experience

View profile

DPA: Would not be able to do my job well without it!

Rating: 10 out of 10

Incentivized

March 15, 2019

Use Cases and Deployment Scope

I am the sole user of DPA and use it to monitor our two primary Oracle SE production databases running on VM. I use it to monitor resource usage, blocks, waits and make good use of the tuning advisor. The databases are hybrid OLT/warehouse with automatic data loads happening 24x7 and heavy reporting processes during business hours. DPA helps me balance performance between these.

Pros

The tuning advisor quickly guides me to where the biggest performance issues are.
There's a lot of built-in "help," definitions and possible actions to take.
Alerts and trending information are very helpful.

Cons

I have to frequently and repeatedly click the "Dismiss" button on banner messages that appear at the top of the screen. They're just annoying.

Likelihood to Recommend

I'm not very familiar with Oracle Enterprise Tuning packs, etc. but for Oracle Standard Edition uses, I believe DPA is an affordable solution for providing similar types of monitoring.

Elizabeth Davis-Noland

IT Manager in Information Technology at Air Resource Specialists (Environmental Services, 11-50 employees)

Vetted Review

7 years of experience

View profile

DPA is A-OK

Rating: 8 out of 10

Incentivized

March 1, 2019

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.

Joshua Head

Systems Operations Engineer in Engineering at Qv21 Technologies (Logistics and Supply Chain, 11-50 employees)

Vetted Review

1 year of experience

View profile