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?

26 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

(1-25 of 113)
Companies can't remove reviews or game the system. Here's why
Michael P. O'Hara | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Our e-commerce platform = crown jewels (i.e. all revenue flows in via website). Knowing the in/outs of DB performance is a business requirement.

DPA is a *tremendous* tool. It provides a deep dive across all critical metrics on our ORA RDS & EC2. I find the table/query advisories to be of great use.

Would deploy across any DB if I could - the info is gold.
Stan York | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Spitfire deploys a software platform backed by a Microsoft SQL Database with over 140 tables and more than 650 procedures. The size of the database typically surpasses millions of records and several hundred GB. SQL creates query plans that differ for each client depending upon their unique distribution of data. Some have only a few dozen projects a year - others a couple of thousand. Clients create budgets with different levels of detail and then create material purchases - sometimes one line each, others 500 lines. So a one-size-fits-all query is a challenge. SolarWinds Database Performance Analyzer gives us real-time, ongoing visibility into the performance of our queries across a real-world deployment.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
SolarWinds Database Performance Analyzer is our primary monitoring and analysis tool for our SQL server instances. We leverage it for both production and non-production environments. It gives us visibility into system and query performance, alerts us to issues so they can be remediated, and allows us to dig into performance trends of queries and look for key opportunities to make our systems more performant. It is used both by our DBAs and our development team.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use it to monitor the company's production SQL server. It's being used by the IT infrastructure and the Development departments. Mostly, it gives us an insight into what is going on behind the scenes and if there are any problems with the SQL server, if it's being slow, which queries are causing problems, etc.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use DPA for database monitoring across the enter enterprise, dev/QA and production. We connect it to Oracle, SQL and MySQL Database Servers. We use DPA as a single source of monitoring for database performance issues. The historical and real-time query monitoring allows us to troubleshoot and quickly identify the root cause of a poorly performing server.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
It allows us to keep a close eye on our database. In the event we run into slowdowns, we can easily identify the issue using SolarWinds Database Performance Analyzer before larger issues pop up. Since we've implemented it, we are able to proactively keep our system running smoother with fewer service interruptions.
Nikhil Kumar Sharma | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
We are using Solarwinds Database Performance Analyzer for few of our customers to help in monitoring their Database Environment which includes Microsoft SQL, Postgre SQL, Oracle etc. Solarwinds DPA is primarily used by Database Administrators, Application Engineers (Read Only) and Tools Administrators. There are few interaction with Key Management stakeholders for data analysis but its relatively less.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use the alerts to prevent problems. We use the performance data to diagnose and fix problems. We use the dashboard and drill down to know where we are at/know if we're doing well. We monitor any spikes or dips in overall response time to try to understand why users are having the UX they are experiencing.
Gus Gwynne | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
It is used by the database team to monitor and tune database performance in both SQL Server and Azure Databases. Slow databases, timeouts on websites and in services and applications, can frequently be caused by the data layer, and this is the best tool I've ever used for troubleshooting that.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
In our company we use SolarWinds Database Performance Analyzer for proactive performance monitoring and anomaly detection in database overall health. This product gives us a first look at the big picture of the database performance. We configured some alerts and mail notifications, which saves us a lot of time. Our most common use case is to react to changed execution plans and take appropriate actions before end users of the systems start to complain about performance problem and response times.
March 22, 2022

DPA: FTW.

Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use SolarWinds Database Performance Analyzer to fine-tune SQL Server workloads and alert us to unexpected issues occurring on our database clusters. It helps us to see problems before they happen - long running queries or unexpected disk thrashing and to fix these problems before users become aware of a situation.
Jennifer Aguilar | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
The tools you decide to use in your environment are only as good as the effort put in to make it a valuable asset to your organization. We run a Computer Aided Dispatch application that looks like a wagon wheel with interfaces. The application interfaces communicate to a database instance running in a cluster. Database Performance Analyzer has allowed our organization to fine-tune the database to the extent that we now know exactly when the database may be experiencing issues. The issues before used to be queries and users (machines). The database is running so efficiently now, we drill down to the machine that is causing the issue. It is generally a user that has kicked off a query that they should be running against the reporting server, not the live database. DPA is an amazing tool. I have a dashboard of off the "current" 10-minute slice in time. I can tell by a visual look if something is not right.
Andre Du Plessis | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
SolarWinds Database Performance Analyzer has been a crucial part of maintaining uptime on our databases. It helped find many issues, current or historical, on our databases. The main use case for getting SolarWinds Database Performance Analyzer in the first place was to find out why we were having application problems and remove the black box state of our databases. Except for this, SolarWinds Database Performance Analyzer has proven useful in other areas as well such as the overall maintenance and performance analyzing of our databases.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
SolarWinds Database Performance Analyzer (DPA) is used by our organization for monitoring our Oracle and SQL Server Databases. It is a complete Database monitoring and performance management tool used by our Database Team for optimizing Database performance and fine-tuning. It identifies bottlenecks and root causes for any issues related to the database. It has inbuilt anomaly detection for proactive monitoring (machine learning). It helps identify issues related to Storage IO, provides Query and Table Advisors for fine-tuning database queries, resources being used by the databases (CPU, Memory, Disk, ASM, etc.)
Mike Saedi | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
As a consultant, I recommend and use SolarWinds across multiple clients currently at Nortek/Broan-Nutone, BlastMotion, and Hansen and Adkins. I use this on a daily basis to assist me with monitoring SQL servers and assisting me with troubleshooting performance issues as they arise. I have also used SolarWinds DPA to set up alerts for issues like low drive space and query plan changes.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
It is being used mostly by the development team as a self service gateway to view the database transactions that they don't have physical access to. This allows the database team to not have to take time out of their day to perform query analysis, etc..
Score 9 out of 10
Vetted Review
Verified User
Incentivized
SolarWinds Database Performance Analyzer is used by the whole department, mainly for addressing performance issues; deadlocks; growth of database; DB reports; server reports; CPU, memory, and disk health; and their storage.
We're also setting up alerts as per the requirement.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
[SolarWinds Database Performance Analyzer is] used to monitor the performance on mission critical application databases, both bespoke and packaged applications. For bespoke applications, it is used to ensure that the code developed by our technology partners meets or exceeds the defined SLAs, as well as to alert of problems before they become critical issues. For packaged applications, it has been used to extract detailed information on performance issues, such that we were able to log extremely detailed issues with the vendors, such that they have all of the information needed to correct the underlying issue. For example, we were able to extract the run time of stored procedures, including all of the SQL statements executed, such that the vendor was able to pinpoint the issue rapidly and provide a resolution.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use [SolarWinds Database Performance Analyzer] for performance analysis for Oracle targets. It is used by the Infrastructure Department. It solves performance problems as they happen, or historically.
Joseph Dixon | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
SolarWinds Database Performance Analyzer is being used by IT in our organization. It allows us to have a better window into what the SQL servers are doing, especially with regards to applications that are using these SQL servers. It allows us to root cause problems and to find problems before they become bigger problems.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use it at the data warehousing and analytics group to monitor the load and set up alerts on the data warehouse server. We have set up alerts on long-running queries, blocking other queries, deadlocks, instance availability, unused indexes, etc. Some of them are very useful, but the deadlocks alert can be improved to show what queries were in the deadlock, so we can improve our solution.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use it across our department to monitor our database landscape. We have different flavors of databases across our landscape, and SolarWinds for years has been an important part of the strategy for our monitoring solutions for the database tier across the landscape. It is very intuitive and quite easy to implement.
Return to navigation