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>
173 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Do you work for this company? Manage this listing

TrustRadius Top Rated for 2019

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Reviews (1-25 of 90)

Pat Groce | TrustRadius Reviewer
November 23, 2019

DPA in Govenment

Score 8 out of 10
Vetted Review
Verified User
Review Source
The database team uses DPA to manage up to 50 licenses. Only 5 team members who are DBAs actively use the tool. All SQL performance problems from large PeopleSoft DBS to Cots applications (500+) are covered. Performance problems can come from all directions so this tool is extremely useful because it's a catch-all.
  • 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.
I find the number of databases we support is high compared to the staff DBAs available. The DPA product is a good product here. If you had just a couple of databases it wouldn't be necessary.
Read Pat Groce's full review
Dave Cheng | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
Discovering data performance issues. Creating an index based on the suggestions by DPA. It can be accessed by all developers to review their query or performance-related issues.
  • Suggest indexes.
  • Indicate the wait time for all processes, so you rank the issues and fix them by priority.
  • You can send URL/ links to other to show them the exact point of problem. Easy for collaboration.
  • Bookmark of problem, so we can revisit the issue and compare it before and after the changes.
  • More details on deadlocks/blocking, etc.
  • Notification, kind of monitoring, if wait time exceeds some threshold.. or review the wait time of specific bookmarks or issues.
We may have navigation issues ... The back button is not very consistent on all pages. Sometimes we have to go back to the home page and start over on the server again.

Some queries, which only run very rare, but require a lot of waiting time whenever they do run (all queries that take longer than 60secs).
Read Dave Cheng's full review
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
It is used in IT to monitor database performance and to assist with troubleshooting when there are performance issues with key applications. It is primarily used by our Database Administrators and has assisted in maintaining key performance metrics. It has allowed us to be proactive in our approach to performance monitoring and being able to resolve problems before they affect users.
  • 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
Recommended overall for database operations and management. The tool is key and has played a good role in providing key information for troubleshooting. It can, at times, present information in a way that can be confusing. But, the application is also very useful for maintaining application-specific metrics that can be used in SLAs and performance metrics.
Read this authenticated review
Anonymous | TrustRadius Reviewer
January 24, 2020

DPA Pros and Cons

Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • Query Analyzer
  • HA Status
  • DAG HA Analyzer
  • Custom Time Windows for history
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.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
It is being used to monitor all production instances for the whole organization.
  • 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.
DPA works best for administrators that have some control or input to the queries that are being issued. If queries come from purchased applications, the best admins can do is play with indexes and resource tuning. DPA is really great for all administrators to monitor the overall status of servers.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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)
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.
Read this authenticated review
Anonymous | TrustRadius Reviewer
August 02, 2019

Small Teams use of DPA

Score 9 out of 10
Vetted Review
Verified User
Review Source
DPA is being used by the IT and CIM Developers team to monitor our production databases. IT will check the system daily for any signs of issues. Both teams will check when testing or rolling out new systems to ensure the Software is operating as intended. These testing checks are done at least once a week by either department.
  • Quickly identifies slow running queries.
  • Identifies which database is causing issues on a server.
  • Provides an easy to read way of seeing stats on all servers quickly.
  • No way to mark a query activity as normal, for example a slow running SPROC that has to be that way.
  • Not many options to restrict access.
DPA is very useful for finding blockers or slow running queries and provided evidence of improvement after an issue with a new system, the graphs and ease of use meant that we where quickly able to resolve the issue and provide comprehensive updates to a customer who was concerned around the software's performance
Read this authenticated review
Anonymous | TrustRadius Reviewer
November 24, 2019

Would be lost without it

Score 9 out of 10
Vetted Review
Verified User
Review Source
Used to monitor production database performance and identify areas for tuning.
  • Allows instant identification of highest impact performance issues
  • Provides visibility of database load across the application
  • Easy to configure and use
  • It's a great product. I really can't identify any cons.
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.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Within our organisation, we use SolarWinds to monitor the most important applications. We give permissions to our customers to view their own data. DPA is saving us on logging in on servers and telling the customer to modify their application (they can see it themselves and fix it themselves). Also it gives us background information on the Virtualization layer and their isseus. It is really helpfull as a first responder to a customer with performance questions.
  • monitor databases
  • monitor servers
  • monitor on virtualisation isseus.
  • adding permissions for users or domain groups
  • adding boxes is not easy
  • being able to remove servers after x month (automagically or via an API)
DPA is well suited in larger environments. In a MSP model it is not very usable because of all the open ports needed. The culprit of agentless operation.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Solarwinds Database Performance Analyser across several teams in and around the IT department. It's used to pinpoint issues with databases or SQL statements, generally on production databases. While Solarwinds Database Performance Analyser won't tell you anything that a real live DBA wouldn't be able to find out, it does allow non-DBAs like myself to get an initial problem diagnosis quite quickly and suggest to the relevant teams where they should be looking to resolve the problem.
  • Pinpoints potential issues with databases.
  • Suggests remediation for these problems.
  • Allows you to narrow down to particular points in time where the problems were observed.
  • It does take a while to gather enough data to suggest problems and fixes. Generally speaking, while you'll get some data back in an hour or two, you want at least 2 days of monitoring to get the best results.
  • Licensing is a bit restrictive.
  • Switching licenses between monitored nodes is a bit annoying.
This is an excellent tool to allow non-DBAs insight into the inner workings of a database server. I'll provide suggested solutions that, while they should be verified by an actual DBA, allow for initial problem diagnosis. Don't expect this tool to instantly fix your database problems, though. It takes a couple of days to get enough data for accurate diagnosis and suggested remedies, and just because an index might help doesn't mean that it will!
Read this authenticated review
Anonymous | TrustRadius Reviewer
January 23, 2020

DPA user

Score 9 out of 10
Vetted Review
Verified User
Review Source
It is used for database performance monitoring. It has helped us in addressing slow queries and other resource issues.
  • Highlights slow queries.
  • Drill down options to the second for troubleshooting.
  • Better suggestions for indexes.
It is well suited to troubleshoot slow queries. I like the new Tuning Advisor section.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use it to monitor and performance-tune some of our in-house developed applications. Some of these applications are tier-one applications.
  • Track historical performance.
  • Isolate the issue by providing a specific area of query impacting performance.
  • Can track which user is causing the issue.
  • Provides quick indexes where it makes sense.
  • Auto tuning - It doesn't have the ability to implement the changes like Oracle Enterprise Manager.
  • DPA free version is good but fully functional version should be allowed free for a limited number of instances to give users the ability to try functions without a need to make a purchase.
It is very appropriate in an environment where you have programmers making changes to an application. It may not work much for a canned application where the performance is already tuned.
Read this authenticated review
Maria Cristina Dela Pena | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
DPA is one of the support tools used by our organization, deployed on some departments where legacy system databases still exist. It empowers our operations when it comes to response time and ability to provide good reporting presentation. I've been in IT Service Delivery and Operation for 10 years, from my experience with different infrastructure and application issues, most of the pain points we've had is the application performance related problems. One of the stories I can share is that it enables us easily detect what is causing bottlenecks and as such good collaboration has emerged with our developers whether the issue lies on our databases or on their codes.
  • Maintainability and accommodating Support service and easy to follow Release Notes/Documentation.
  • The relevance of the pre-defined Reports and Checks.
  • Simplicity of the tool. Easy to use and understand.
  • Resiliency of the Monitoring checks after the server underwent maintenance reboot. My experience is the monitor (Action) needs to be started manually. If possible it can automatically detect service/server then start to monitor again when system is back up.
  • Much lighter UI.
  • Granularity up to minutes.
It is best suited for batch jobs processing databases and maintains on-premise infrastructure. It will only be less appropriate if the organization or company is completely running databases on a managed cloud platform as there are available tools for monitoring systems health. However, it is also useful for cost optimization for cloud database users. It is also beneficial to operations to easily pinpoint the performance related issue and prevent ping pong with developers.
Read Maria Cristina Dela Pena's full review
Paul Land | TrustRadius Reviewer
May 01, 2019

DPA: FTW.

Score 8 out of 10
Vetted Review
Verified User
Review Source
We use DPA to manage a very large and somewhat cranky SQL environment for ambulatory healthcare end users (from providers and office managers to assistants and front desk personnel). The DB schema dates to the 1990s and requires regular supervision and management at a level the system vendor doesn't provide. Addressed problems include plan management, index addition and revision, partitioning and troubleshooting poor performance.
  • Near-instantaneous feedback on problem queries
  • Allows us to evaluate changes in the application or its stored procedures over time
  • We can drill down to the end-user level to identify potential issues, important with > 2000 sessions daily
  • Can't think of any feature or ops related issues. Prior complaints have all been addressed in newer updates.
  • Only main complaint is cost -- we would adopt for other servers if the incremental cost wasn't so high for a few additional instances (we have 3 servers we would like to use DPA with, but can't justify the x3 pricing per instance).
Well suited for large-scale implementations of SQL Server in distributed environments.
Read Paul Land's full review
Kev Shawhan | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
To support performance monitoring for SQL servers across the organization.
  • Monitors both SQL query performance and back end VM resources.
  • Easy to read trend charts, bottlenecks or spikes show up immediately.
  • East to drill-down into specific issues.
  • Very good settings for alerts.
  • Poor interface for managing alert times or blocking out alerts at times of the week. Very tedious process.
Read Kev Shawhan's full review
Darryl Hawes | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
It is being used to monitor the ERP database, providing insights on performance and long-running queries. The alerts are used to notify of high license usage and deadlock events.
  • The alert configuration is very robust, allowing simple OOTB alerts as well as complex query-based alerts.
  • Blocking event tracking makes it easy to identify if a user's performance issue is a truly server-related performance problem.
  • Historical tracking of queries allows me to easily identify frequently used statements that might need tuning.
  • Some of the navigation leads to points that cannot be easily backed out of.
  • Some navigation points lead around in circles.
  • I would like to see index usage statistics as well as fragmentation.
The more heavily a database is used, the more useful DPA is. A lightly used database will not get a lot of benefit. The business use of the database will also correlate to DPA's usefulness. In cases where performance can make or break a company, DPA can allow for a huge impact, if done right.
Read Darryl Hawes's full review
Mohamed Shameer | TrustRadius Reviewer
July 17, 2019

Life saver!

Score 8 out of 10
Vetted Review
Verified User
Review Source
DPA is used to monitor the performance of Oracle and MSQL databases. We added a highly critical system in DPA, and DPA can suggest performance enhancement based on findings over the period, like missing indexes and statistics. Also, during ad-hoc performance issues, this helps to identify the current performance, because of easy access like running a session, blocking, and querying a program that is running.
  • Index recommendation.
  • Tuning advisor.
  • Wait events.
  • Always-on monitoring.
It's an easy tool to know performance bottlenecks, though the DBA is not from a performance expert background.
Read Mohamed Shameer's full review
Arun M | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
We use this product across the whole organization for multiple applications.
  • Easy to use.
  • Flexible.
  • A good tool to analyze DB performance.
  • Needs a more alert setup
  • Needs 24/7 support.
I feel that SolarWinds Database Performance Analyzer makes it easy to identify DB issues and helps us to resolve performance problems proactively. We implemented SolarWinds DPA on more than 450 servers in the last year, but sometimes we are facing an issue with data collection. Also, there is no 24/7 support, so it's very hard to reach the support team during the US night time.
Read Arun M's full review
Craig Solinski | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We run six separate DPA servers covering three different database software vendors. Coverage includes TEST Databases where developers can instantly observe metrics from their most recent changes. Production coverage, of course, is crucial to rapidly identify SQL and VM performance matters and observe changes based on the volume of transactions. This tool is the first place hundreds of developers, admins, and managers use to check app performance.
  • Top N SQL queries.
  • Outstanding UI for rapid examination and drill down to detail data.
  • Intuitive UI design - better than any other product in its category.
  • Enabled us to immediately shift DB related performance matters first to developers so that our DBA's can focus on more important matters.
  • Allow alerts to SMS (text message).
Extremely reliable and bug-free software that can be used over hundreds of databases of various types when run from multiple servers. When monitoring virtual machines, it also reports the VM metrics. Best in class for ease of use and net result value to developer/manager/admin.
Read Craig Solinski's full review
Gus Gwynne | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
It is used by the database team to monitor and tune database performance in both SQL Server and Azure Databases.
  • Tells you which statements in which stored procedures need work or are catastrophic (if that applies).
  • Helps you focus attention on what really needs work, very efficiently.
  • I can't think of any examples for this question.
It works really well if you either have a limited number of servers or if you are focusing your attention on a small number. If you have a ton of micro-databases, it's not going to be the best option.
Read Gus Gwynne's full review
Emmanuel Bradley | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Solarwinds Database Performance Analyzer is being used to monitor for issues with our SQL Servers by our organization. We use it to provide a baseline and display opportunities for improvement. The tuning feature helps us find bottlenecks and provide index suggestions. Our software development department uses the tool to show how the code has affected database performance. The network operations department monitors the data to find areas that may need upgraded hardware or configuration changes.
  • 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.
Solarwinds Database Performance Analyzer is well suited for general monitoring. If you are interested in overall trends and issues that have a significant affect on performance, then this tool works well. It is less appropriate for deep dives into specific issues. When trying to monitor new changes, the impact must be big enough to display a difference in the charts.
Read Emmanuel Bradley's full review
Steve Shandro | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
Beyond day-to-day monitoring, the DPA (Database Performance Analyzer) is key to anyone who needs to look back in time to provide Trending and/or Root Cause Analysis, whether database related or not. There are suspects and culprits, and this product can help to identify them. DPA is very, very detailed, and you can zero in on an issue, all the way down to a minute timeframe if you are willing to do the cross analysis work. This product is A+ and can be used for Oracle, MySQL, and SQL Server.
  • Problem categorization.
  • Problem identification.
  • Serious trending analysis.
  • When presenting possible sources of issues, it may be better to first give a list overview, and then proceed to drill down into the details.
Suited to root cause analysis (but you also have to do your cross-analysis).
Read Steve Shandro's full review
Ariel Portocarrero | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use SolarWinds Database Performance Analyzer to predict the behavior of our campaigns and e-marketing. With SolarWinds Database Performance Analyzer, we can check the performance of our databases and how the behavior will be during high load works in the season and spikes that are associated with our day by day jobs.
  • Predict performance across all databases
  • Predict unexpected behavior
  • Make a correct forecast about how much memory and CPU could be needed for a particular job
  • The agent usually consumes a lot of memory
  • High cost, since it is charged per instance.
  • An efficient and intelligent search feature would be helpful.
SolarWinds Database Performance Analyzer is a really good software for monitoring purposes. If your company is e-marketing related, this is a good tool since you can see the overall trends and issues that cause a significant effect on performance when campaigns are being sent. But it is not good enough for deep dives into specific issues related to Database.
Read Ariel Portocarrero's full review
Mohit Tiwari | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Monitoring databases is always a critical topic for a database administrator, but SolarWinds Database Performance Analyzer made is easy with real-time monitoring for DB status using query's hash, CPU time, programs, database query plans. Users, as well there other machines for correlation DB integration in multiple databases, query analyzer helps to display the historical graphs for understanding the behavior and provide reports complete for first glance understanding of abnormal or normal statuses.
  • Multiple database real-time performance/status in single windows with an easy illustration using graphs.
  • Query analyzer and identify plan text.
  • Overall database status monitoring and reporting.
  • Plan hash and plan adviser.
  • DB color and grouping for interdependent query's relation.
  • Point the users and identify single users for multiple DB Access Scenarios.

Well suited for database real-time status and performance monitoring and reporting, an easy illustration of a query in graphs for user understanding, interdependency and query identification and a single glass view for multiple different databases.

Not as good for failed jobs status for a database, identifying a single user while it's using multiple database correlations or logging into multiple databases. The Adviser plan and suggestions are not always helpful to the administrator in relation to the alerts or abnormal behavior.

Read Mohit Tiwari's full review
Alexander Veitschegger | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
It is used in the whole company for analyzing problems or performance issues on all SQL Servers which hold in-house created DBS and commercial products. It is vital for reviewing what happened during weekends or spare days. Also vital, is the development of the wait time of some servers for future sizing.
  • Very easy to use user interface. Also very handy for new users with a short time of introduction.
  • Very good overview on all servers added. You can see in one sight which servers are busy.
  • Well created metrics, a good starting point for adapting them.
  • Alert system is very useful.
  • No possibility to create overview groups to bundle SQL servers in more than one group.
  • If an agent has an error there should be the possibility to send an alert.
  • No support for by-products.
Can be used very well for performance analysis or depth analyzing of reported performance issues in the past. Not so well suited for a live problem as there is a time gap between the 'real' now and the analysis of DPA. But in a company with a SQL server activity tab, it is a great tool.
Read Alexander Veitschegger's full review

SolarWinds Database Performance Analyzer Scorecard Summary

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 Video

Database Performance Analyzer - Overview

SolarWinds Database Performance Analyzer Downloadables

SolarWinds Database Performance Analyzer Integrations

SolarWinds Database Performance Analyzer Competitors

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