Skip to main content
TrustRadius
SolarWinds Database Performance Analyzer

SolarWinds Database Performance Analyzer

Overview

What is 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? OracleOracle ExadataOracle EBSMicrosoft SQL Server Azure SQL DatabaseAzure SQL Database Managed InstanceMySQLDB2 SAP ASE AuroraMariaDBDPA monitors…

Read more
Recent Reviews

TrustRadius Insights

User-Friendly Interface: Users appreciate the SolarWinds Database Performance Analyzer for its straightforward and easy-to-understand …
Continue reading

DPA: FTW.

8 out of 10
March 22, 2022
Incentivized
We use DPA to manage a very large and somewhat cranky SQL environment for ambulatory healthcare end users (from providers and office …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is 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…

Entry-level set up fee?

  • Setup fee optional

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

28 people also want pricing

Alternatives Pricing

What is SolarWinds SQL Sentry?

SolarWinds SQL Sentry is designed to help data professionals optimize SQL Server database performance in physical, virtual, and cloud environments. SQL Sentry delivers metrics to help users find and fix database performance problems and provides scalability, boasting demonstrated success monitoring…

What is dbForge Studio (Edge)?

dbForge Studio is provided by Devart and is a universal front-end client for database management, administration and development. Devart's GUI tool provides utilities to compare, synchronize, and back up databases (e.g. MySQL, Oracle, SQL Server, PostgreSQL, etc.) with scheduling, and includes the…

Return to navigation

Product Details

What is 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

  • Supported: Database monitoring
  • Supported: Tuning advisors for queries, workload, and indexes aggregated at the table level
  • Supported: Correlated resource metrics for easy diagnosis of hardware constraint impacts on end-users
  • Supported: Detailed blocking analysis for contention bottlenecks
  • Supported: I/O activity tracking at the drive/mount and file level
  • Supported: Alerts and reports
  • Supported: DPA Central to manage large and/or distributed environments
  • Supported: Always On Availability Group and RAC insights

SolarWinds Database Performance Analyzer Screenshots

Screenshot of DashboardScreenshot of Alerts and reportsScreenshot of Application-centric view of DPAScreenshot of Blocking deadlock analysisScreenshot of Collaboration across teamsScreenshot of Intuitive performance monitoringScreenshot of Performance intelligenceScreenshot of Query performance analysisScreenshot of Real-time & historic monitoringScreenshot of Recommendations

SolarWinds Database Performance Analyzer Videos

Azure Database Support Overview

Watch Product Overview

SolarWinds Database Performance Analyzer Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows, AWS Marketplace app
Mobile ApplicationNo

SolarWinds Database Performance Analyzer Downloadables

Frequently Asked Questions

Foglight, Spotlight, and Idera Uptime Capacity Monitor are common alternatives for SolarWinds Database Performance Analyzer.

Reviewers rate Solarwinds Premier Support Rating highest, with a score of 10.

The most common users of SolarWinds Database Performance Analyzer are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(227)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

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.

Dated and Confusing User Interface: Several users have expressed frustration with the user interface, describing it as dated, confusing, and difficult to navigate. They suggest that the user interface could be more user-friendly and have a reduced learning curve. Some users also mentioned that the navigation can be unintuitive and sometimes tough, and that some items can be confusing to find again. Overall, improvements in the cosmetic aspects of the user interface are needed.

Lack of Reporting Flexibility: According to some users, there is a lack of flexibility in both dashboard customization and reporting capabilities. They feel that the reporting feature needs improvement to provide more options for customization and analysis. This limitation hinders users' ability to obtain meaningful insights from their data.

High Cost: The cost of the software has been a major complaint among some users, particularly when it comes to adding additional instances. These users mention that the licensing timeline needs improvement as adding new instances becomes cost-prohibitive during certain periods of the year. The high cost associated with using this software can limit its accessibility for businesses operating on tight budgets.

Users highly recommend trying the free trial and evaluating SolarWinds DPA before purchasing. They suggest taking advantage of the free demo and training resources provided by SolarWinds. Users advise implementing SolarWinds DPA for monitoring and analyzing databases, especially for those who are just learning. The software is also recommended for DBAs in small to medium businesses and for integrating with other SolarWinds products for better data analysis. Additionally, users suggest comparing it with Idera offerings for SQL performance monitoring and highlighting it to DBAs as they will likely find value in it.

Attribute Ratings

Reviews

(26-50 of 113)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Incentivized
The historical record aspect to view performance over time is invaluable, to be able to go back and see when things change which can then be related to application changes is great. Additionally, the live reporting current detail is brilliant for out of the blue and immediate issues that have to be dealt with.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
July 17, 2020

DPA Pros and Cons

Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
SolarWinds Database Performance Analyzer is great for any company that uses some form of SQL server in their environment. Whether it's Microsoft SQL Server, Oracle, Sybase, etc, SolarWinds Database Performance Analyzer provides insight into your environment's health.
In order to fully utilize and appreciate SolarWinds Database Performance Analyzer, I do recommend you have some experience with SQL queries and databases, as some of the suggestions and issues that could arise needs to be fully understood prior to implementing the suggested fixes.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
In an environment where many developers and DBAs are often working separately from each other on some projects and together on others, it gets difficult to see where the lines are between applications and databases. SolarWinds Database Performance Analyzer allows me as a manager to pinpoint issues and to get our developers or DBAs involved as appropriate to resolve issues that happen, and address issues that haven't happened yet. SolarWinds Database Performance Analyzer is worth a whole 9 of uptime in and of itself.
February 07, 2020

SolarWinds DPA review

Score 8 out of 10
Vetted Review
Verified User
Incentivized
Best suited in a three-tiered environment where there is a web application, middleware, and a DB in the backend. Not suited in stand-alone DB environment like backend DB for a static website. DPA is also very well suited when troubleshooting the application performance related issue. It gives a clear picture of the issue.
January 29, 2020

Just works!

Score 10 out of 10
Vetted Review
Verified User
Incentivized
We have used the product in more than one situation. One time we were analyzing an SQL database and had issues connecting. We used the software to see how we could correct any issues by the attempts it made to connect and to determine if there were any conflicts and how to work with the results.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
November 24, 2019

Would be lost without it

Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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!
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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).
August 02, 2019

Small Teams use of DPA

Score 9 out of 10
Vetted Review
Verified User
Incentivized
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
Return to navigation