SolarWinds Database Performance Analyzer Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
195 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.7 out of 100

Do you work for this company? Learn how we help vendors

TrustRadius TRUE BadgeTrustRadius Top Rated for 2020

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-25 of 101)

Companies can't remove reviews or game the system. Here's why.
Joseph Dixon | TrustRadius Reviewer
November 03, 2020

Solarwinds DPA - a DBA's MVP!

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Insight into query wait times
  • Ability to view Disk IO
  • Historical trending of wait times
  • Dated UI
  • Development servers are not free
  • Dashboard visualization of stats requires Solarwinds Performance Monitor (Included with Orion)
Read Joseph Dixon's full review
Emmanuel Bradley | TrustRadius Reviewer
July 17, 2020

Great for general monitoring

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Displaying baselines helps to show management how a change has affected performance positively or negatively.
  • The tuning feature is helpful in showing areas that could be improved with an index or code updates.
  • Wait statistics information is very helpful to diagnose database bottlenecks.
  • Naming the hash takes more steps then it did in the past.
  • It would be nice if there was a way to group the wait statistics by procedure.
  • I search feature would be helpful.
Read Emmanuel Bradley's full review
Mike Saedi | TrustRadius Reviewer
July 21, 2020

SolarWinds DPA is an Excellent Performance Monitoring Tool for SQL Server

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Excellent for trending SQL Performance over time.
  • Excellent for monitoring deadlocks and blocking.
  • Good for trending SQL query changes over time.
  • It would be nice to have more built-in alerting capabilities.
  • Indexing recommendations are also somewhat unclear. I have seen areas that say you could improve performance on a table for example but not giving any additional details beyond that.
  • More in-depth recommendations, other tools like Idera Diagnostic Manager I feel are stronger in this area.
Read Mike Saedi's full review
Pat Groce | TrustRadius Reviewer
July 14, 2020

DPA in Govenment

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Peoplesoft DBs: we often use it to recommend indexes or find queries that need tuning.
  • Availability group monitors and alerts so we know when there are problems.
  • Trends over time: like blocking, deadlocks or stuck queries DPA helps pinpoint the cause.
  • Bug with fantom availability group.
Read Pat Groce's full review
Anonymous | TrustRadius Reviewer
July 17, 2020

SolarWinds Database Performance Analyzer - Recommended

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Automatically emails me weekly reports so I can keep an eye on our database performance.
  • Easily identify problem queries.
  • Helps us optimized our code.
  • The initial learning curve is a little steep.
  • A better explanation of the features would be nice.
  • Navigation is sometimes a little tough.
Read this authenticated review
Anonymous | TrustRadius Reviewer
July 17, 2020

SolarWinds DPA is a great product to visually see the health of the databases and make a proactive monitoring and root cause analysis

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Anomaly detection powered by machine learning - new in version 12, greatly love that statistical analysis
  • Compare workload versus past on daily basis and total, it really helps us to see big picture of growth and make capacity considerations
  • Intuitive performance analysis - easyly examine the problems and find the root cause
  • In the last two versions 12.0 and 12.1 SolarWinds has made great enhancements. I do not have a thing that I currently want to be changed. There are some cosmetics in the user interface but do not think that they are problems.
Read this authenticated review
Anonymous | TrustRadius Reviewer
August 14, 2020

SolarWinds Database Performance Analyzer Review

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • We have set up alerts on long-running queries, blocking other queries, deadlocks, instance availability, unused indexes, etc.
  • The status summary is useful to see the load on the server.
  • Deadlocks alert can be improved to show what queries were in the deadlock, so we can improve our solution.
  • Deadlocks alert can be improved to show what queries were in the deadlock, so we can improve our solution.
  • We never got to setup https using the documentation provided by solar winds. We still keep getting https error when we access our DPA site.
  • A better technical customer service would help.
Read this authenticated review
Anonymous | TrustRadius Reviewer
July 20, 2020

Try it out if you want happy customers

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Immediate bottlenecks on the database tier.
  • Performance tuning.
  • Historical reports.
  • 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.
Read this authenticated review
Anonymous | TrustRadius Reviewer
July 14, 2020

Top of Class Database Performance Monitoring and Tuning Advisor!

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Database performance monitoring.
  • Database performance root cause analysis.
  • Server performance monitoring.
  • 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).
Read this authenticated review
Anonymous | TrustRadius Reviewer
July 14, 2020

Key to knowing true DB performance

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Monitoring DB performance
  • Insight into hard hitting queries or jobs
  • Visual representation
  • Can be better in presentation of issues
  • Would be good if it could provide possible causes or solutions
Read this authenticated review
Anonymous | TrustRadius Reviewer
July 19, 2020

SolarWinds DPA is a great tool

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Measures wait times of queries performed on our Sybase database
  • Displays the current queries being performed on the database
  • Displays, in a user friendly display, the status of the database
  • Searching for specific users
  • Examining which processor is running which query at the time
Read this authenticated review
Anonymous | TrustRadius Reviewer
July 17, 2020

DPA: The Advance DBA Tool

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Details query capture with the plan and resource utilization.
  • DPA backend is an SQL server that you can control by performing some operations from the backend like change in retention, etc.
  • Supports latest SQL features like AG.
  • Report features are very good
  • License management. DPA is not able to sync licenses and needs you to manually reconcile every time.
Read this authenticated review
Aruna Bandara | TrustRadius Reviewer
April 18, 2020

Keep an eye on your databases using Solarwinds DPA

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
  • 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.
Read Aruna Bandara's full review
Kiran Yakkala | TrustRadius Reviewer
March 29, 2020

SolarWinds Database Performance Analyzer as a whole

Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Database Performance Analyzer module helped us capture database response times and other info.
  • Database Performance Analyzer is really good at capturing in depth DB data that is not really possible from multiple other modules.
  • Investigating everything is manual in SolarWinds Database Performance Analyzer.
  • We will need to manually figure out what the issues are using SolarWinds.
Read Kiran Yakkala's full review
Steven Pangilinan | TrustRadius Reviewer
February 27, 2020

Real ROI that added a 9 to our uptime.

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Alerts us of current issues affecting system performance
  • Alerts us of potential issues that will affect system performance
  • The licensing timeline needs improvement. Adding new instances becomes cost-prohibitive at some times of the year due to the locked-down renewal period.
Read Steven Pangilinan's full review
Anonymous | TrustRadius Reviewer
March 31, 2020

SolarWinds Database Performance Analyzer helps you become the best DBA you can be.

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Analyzes performance trends with all of the databases
  • Analyzes memory, CPU, and disk space on the SQL servers and alerts on any potential issues
  • Provides stats on wait times by database
  • Offers tuning suggestions on how to improve the performance of under-performing databases and queries
  • query and index suggestions are not straight forward. you need to understand sql in order to interpret and use the suggestions properly
  • if you have a lot of databases, the price could inhibit the implementation
  • not all reported issues have suggested fixes
Read this authenticated review
Anonymous | TrustRadius Reviewer
February 07, 2020

SolarWinds DPA review

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Easy to configure
  • Real time data
  • Notification email templates need improvement
  • Needs a little training to go over/work with dashboards
Read this authenticated review
Anonymous | TrustRadius Reviewer
January 28, 2020

Just works!

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Analyzing data flows.
  • Connection issues clarified.
  • Would love a bolder UI font.
Read this authenticated review
Anonymous | TrustRadius Reviewer
January 15, 2020

One of the BEST at-a-glance database monitoring tools out there.

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Provides meaningful status at a glance.
  • Highly configurable alerts (less spam/noise).
  • Could allow better tuning for summary page information. Sometimes data is a bit stale.
  • Could use better database level summary information in addition to server/instance level.
Read this authenticated review
Anonymous | TrustRadius Reviewer
December 04, 2019

Invaluable, Trusted Performance Diagnostics

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
  • 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)
Read this authenticated review

About SolarWinds Database Performance Analyzer

SolarWinds Database Performance Analyzer (DPA) enables deep visibility into database performance and expert advice for performance optimization and tuning.

What can you monitor with DPA?
  • Oracle
  • Oracle Exadata
  • Oracle EBS
  • Microsoft SQL Server
  • Azure SQL Database
  • Azure SQL Database Managed Instance
  • MySQL
  • DB2
  • SAP ASE
  • Aurora
  • MariaDB
DPA monitors physical, virtual, and cloud-based databases (including Microsoft Azure and Amazon RDS)

What makes DPA stand out:

  • Quick, easy, and reliable performance troubleshooting available in real time and historically

  • Machine learning anomaly analysis to bring intelligence to go beyond traditional threshold based analysis
  • Find inefficient workloads, aggregated by table, for indexing opportunities—an “X marks the spot” tuning analysis
  • Cross-platform database support for a single-pane-of-glass view into your environment
  • Blocking analysis: what is blocking and a hierarchy of what is being blocked, plus overall impact
  • PerfStack™ integration with other SolarWinds products for more complete visibility (applications, servers, storage, hypervisor, network, and more)
  • Agent-less architecture with the ability to scale from a few instances to thousands, low 1% average overhead

SolarWinds Database Performance Analyzer Features

Has featureDatabase monitoring
Has featureTuning advisors for queries, workload, and indexes aggregated at the table level
Has featureCorrelated resource metrics for easy diagnosis of hardware constraint impacts on end-users
Has featureDetailed blocking analysis for contention bottlenecks
Has featureI/O activity tracking at the drive/mount and file level
Has featureAlerts and reports
Has featureDPA Central to manage large and/or distributed environments
Has featureAlways On Availability Group and RAC insights

SolarWinds Database Performance Analyzer Screenshots

SolarWinds Database Performance Analyzer Videos (2)

Azure Database Support Overview

Watch Product Overview

SolarWinds Database Performance Analyzer Downloadables

SolarWinds Database Performance Analyzer Integrations

SolarWinds Server & Application Monitor, SolarWinds Virtualization Manager (VMAN), SolarWinds Storage Resource Monitor (SRM), SolarWinds Network Performance Monitor (NPM), SolarWinds NetFlow Traffic Analyzer (NTA), SolarWinds Network Configuration Manager (NCM), SolarWinds IP Address Manager (IPAM), SolarWinds VoIP & Network Quality Manager (VNQM), SolarWinds Web Performance Monitor (WPM), SolarWinds User Device Tracker

SolarWinds Database Performance Analyzer Competitors

SolarWinds Database Performance Analyzer Pricing

  • Has featureFree Trial Available?Yes
  • Does not have featureFree or Freemium Version Available?No
  • Does not have featurePremium Consulting/Integration Services Available?No
  • Entry-level set up fee?Optional

SolarWinds Database Performance Analyzer Support Options

 Free VersionPaid Version
Phone
Email
Forum/Community
FAQ/Knowledgebase
Video Tutorials / Webinar

SolarWinds Database Performance Analyzer Technical Details

Deployment Types:On-premise, SaaS
Operating Systems: Windows, AWS Marketplace app
Mobile Application:No