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
TrustRadius Insights
TrustRadius Insights

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
Verified User
Manager in Information Technology
Food Production Company, 1001-5000 employees
Return to navigation

Pricing

View all pricing
SolarWinds Database Performance Analyzer

SolarWinds Database Performance Analyzer

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

SolarWinds SQL Sentry

SolarWinds SQL Sentry

Free
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…

dbForge Studio (Edge)

dbForge Studio (Edge)

$9.95
per month
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 Integrations

SolarWinds Database Performance Analyzer Competitors

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

(76-100 of 113)
Companies can't remove reviews or game the system. Here's why
March 15, 2019

Great tool that works for you, not against you

Les Robinson | TrustRadius Reviewer
Les Robinson
Director of Support
Aprima Medical Software, Inc. (Computer Software, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
SolarWinds is dynamic. I have put this in our data center and monitored 5 servers at once. I have split it up between both data centers (2 here and 2 there), then installed it on a customers server to get insight into what is happening. I have run into this issue once or twice, but if you do not have a SQL environment running, Microsoft has a free version of SQL Express. The problem is SolarWinds is not the easiest when it comes to scaling back the information so that it fits on Express. if you only need 5 days or so, then it would be fine.
March 01, 2019

DPA is A-OK

Joshua Head | TrustRadius Reviewer
Joshua Head
Systems Operations Engineer
Qv21 Technologies (Logistics and Supply Chain, 11-50 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
February 28, 2019

DPA Review

GH
Gerald Harper
Database Administrator
Mississippi Department of Human Services (Government Administration, 1001-5000 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It does alerting well once you have the alerts you want setup. Also, it allows for individual and/or groups to be alerted depending on the level of importance of the notification. Helps in identifying queries not efficiently running on the server and how to get them running better. Plenty of community support for customizing.
February 22, 2019

A must have tool for any production dba

Verified User
Director in Engineering
Internet Company, 51-200 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
After working with a bunch of other solutions I admit the best advantage of DPA is a design around wait-events. That's exactly what others are always missing while providing a deep performance analysis. At the end of the day, the most important thing is how long database consumers have to wait for a particular transaction to be finished.
February 21, 2019

My SolarWinds Database Performance Analyzer Review

Justin Wang, MBA, MSc, MMA (in progress) | TrustRadius Reviewer
Justin Wang, MBA, MSc, MMA (in progress)
Director Information Technology
Anatolia Tile & Stone Inc (Building Materials, 201-500 employees)
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
If you have SQL Servers with very heavy workloads, and the applications on the SQL Servers are mission critical, then you better to have a tool like DPA that can help you to monitor the system's performance and help you to do troubleshooting.

The more SQL Servers you have, the heavier the workloads on these servers, the better chance you can get a bigger ROI from BPA.

Compared to the impact to the business on potential downtime due to performance issues on SQL Servers, the cost of getting BPA in place is very minimum.
February 15, 2019

Why DPA can save your firm money, help developers, and ease DBA job.

Craig Solinski | TrustRadius Reviewer
Craig Solinski
Systems Administrator/Programmer
Indiana University (Higher Education, 10,001+ employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
February 02, 2019

Database Performance Analyzer is a great complement to Oracle Enterprise Manager

Verified User
Administrator in Information Technology
Semiconductors Company, 1001-5000 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Database Performance Analyzer is particularly well-suited for two use cases:
1. As a supplement to Oracle's Diagnostic and Tuning Pack features in OEM. It displays database status in a more comprehensive way and from a different angle than OEM. The two tools together provide a particularly powerful ability for DBAs to keep an eye on database performance.
2. Because it is much easier to use than OEM, it is particularly suitable for use by junior helpdesk and DBAs.
February 02, 2019

DPA, the database admin's friend.

Verified User
Contributor in Information Technology
Packaging and Containers Company, 5001-10,000 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
I think if you have any database servers that are used for more then one database it would be a must. The ability to make sure that one database is not hogging the entire server and causing slowness for others is a very good thing to have. If you only have only one database it would be useful, but it might not be needed.
February 01, 2019

DPA - Helping to provide that single pane of glass monitoring for all of IT.

Verified User
Manager in Information Technology
Insurance Company, 51-200 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Assisted in troubleshooting after hours for none DBA analysis. Able to have staff monitor and deliver quicker time to resolution even though on-call engineers are not trained in database technologies.
February 01, 2019

Solarwinds from an application standpoint.

Jason Brokaw | TrustRadius Reviewer
Jason Brokaw
Director of Business Intelligence
Valley-Wide Health Systems, Inc. (Hospital & Health Care, 201-500 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It's freed up a lot of time for me and made me less reliant on running SQL Profiler for long periods of time to gather data to investigate an issue. Now I can just go look at the history and work my way forward figuring out where an issue originated and with whom.
February 01, 2019

Solarwinds DPA: Quickly Identify Production Performance Problems

Verified User
Engineer in Information Technology
Hospitality Company, 1001-5000 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It is well suited for monitoring performance of mission critical business database systems. The tools website provides many easy to navigate pages with a plethora of details about SQL wait times, system resource utilization, such as CPU, memory, and disk, as well as supplying potential missing index information.
January 29, 2019

What a tool !

Natasa Stojsic | TrustRadius Reviewer
Natasa Stojsic
DBA
Reliance Home Comfort (Consumer Services, 1001-5000 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It is easy with SolarWinds DPA to see the database block chains and drill into what is the root blocker process. DPA is less detail oriented when it comes to the infrastructure side of data stores. When infrastructure provisions the SQL server I would like to be able to see for example if the partitions used for transaction log and main data drives are on separate devices/different volumes to reduce IO contention.
January 25, 2019

Database Administrator

Verified User
Engineer in Information Technology
Building Materials Company, 5001-10,000 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Well-suited scenarios: (1) Collecting historical performance data and monitoring system's health with a minimal overhead or performance impact. (2) When you have no existing DPA tool in the environment or are considering purchasing/switching to a different DPA tool.
January 25, 2019

Just my view on Solarwinds DPA. Not worth it to me.

Verified User
Employee in Information Technology
Insurance Company, 51-200 employees
Score 3 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
If you only care about wait time stats, then SolarWinds Database Performance Analyzer (DPA) is probably the best tool around. For the rest of us, I think other tools do the job of SQL monitoring better across the board. Some might have more complex options and longer set up, but that cost is offset by value added over time. Anything outside of wait time stats is probably not done by this tool as well as its competitors.
Return to navigation