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?

27 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

(51-75 of 113)
Companies can't remove reviews or game the system. Here's why
July 19, 2019

DPA: Great web application for wait stats and trends. Not the tool for those needing actionable alerts.

Verified User
Team Lead in Information Technology
Online Media Company, 501-1000 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
DPA is well suited for an environment where a web app is preferred. Especially if there are several users accessing the reports and data. I would also say it's suited for teams with a good amount of SQL knowledge pertaining to wait types. It would be less suited for teams that need a tool to recommend changes to SQL queries to improve performance, as well as those looking for a tool to send out actionable-alerts that can be turned on or off based on actions.
June 28, 2019

Happy customers, much time saved

Verified User
Manager in Information Technology
Retail Company, 51-200 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
For discovering performance bottlenecks, SolarWinds is absolutely invaluable. Once it's installed (which is a simple process) it completely looks after itself. Finding the blocking process can be a real headache in pure SQL, grabbing process IDs and checking manually up the chain until you find the root process - by which time it's often stopped blocking! SolarWinds does this for you without thinking.
June 28, 2019

NCTradeToolReview

Verified User
Engineer in Other
Logistics and Supply Chain Company, 201-500 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
A user jabbers to me that over the last week or so the EDI-messaging appears to be slowing down. My first step of course is to glance at the logs from the database to see if there are any database issues, and I rarely find anything there. My next step is to pull up that customer in DPA and look for trends in the time period the user has described. I have yet to not find a direct correlation to the time periods the user has described and the graphical output in DPA. From there it is a simple task to determine which queries are causing the issue, if it's a resource issue, can it be addressed in the short term or do I need to do further research for a longer term solution.
June 20, 2019

DPA -- The Wait stats king

Verified User
Employee in Information Technology
Computer Software Company, 10,001+ employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
DPA is very useful as a performance monitoring tool for your database servers. If you want a tool to monitor your waits, this is the best tool for the job. Dynamic SQL can be an issue for DPA if you are generating a lot of unique statements, as DPA works at the statement level. Working at the statement level can be a good thing, but a performance issue can sometimes be diluted at this level.
DPA is a performance monitoring tool, and it's good at this task. It doesn't monitor things like backups, log shipping, etc.
June 11, 2019

SolarWinds Database Performance Analyzer

AM
Arun M
Senior Database Administrator
NASDAQ (Financial Services, 1001-5000 employees)
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
June 10, 2019

Great alternative for Oracle Enterprise Manager

Verified User
Professional in Information Technology
Information Technology and Services Company, 1-10 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It's a great alternative to Oracle Enterprise Manager especially when you on a standard database license. If you're in a cloud environment like AWS your monitoring options are slightly limited. It would be great if SolarWinds could add some integrations with CloudWatch and native RDS, Aurora, etc. metrics to correlate database performance with "hardware" metrics.
June 07, 2019

My DPA-review

Verified User
Employee in Information Technology
Hospital & Health Care Company, 1001-5000 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
DPA pinpoints quite well which SQLs could need tuning, and it shows which impact the bad SQL had on the database and which impact the correction has afterwards. The repository collects more and more knowledge of your database as times goes by which enables you to see trends over time. You can very easy customize all kinds of alerts and get alerted (for example, by email) if something serious happens with your database.
June 02, 2019

Great tool for a DBA

Verified User
Manager in Information Technology
Insurance Company, 201-500 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
I first used this product as a demo version on a not well-optimized database. In two weeks of monitoring the database, SolarWinds DPA found several issues that we didn't notice before. It really helped us, as we would not have been able to find all that stuff in such a short time.
May 31, 2019

Awesome Database Best Practice

Maria Cristina Dela Pena | TrustRadius Reviewer
Maria Cristina Dela Pena
Cloud Ops Engineering Sr. Analyst
Accenture (Information Technology and Services, 10,001+ employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
May 15, 2019

DPA is a helpful monitoring and analytical tool

Ariel Portocarrero | TrustRadius Reviewer
Ariel Portocarrero
Global Monitoring Manager
Cheetah Digital (Computer Software, 1001-5000 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
May 09, 2019

SolarWind's products make IT infrastructures work better

Mohit Tiwari | TrustRadius Reviewer
Mohit Tiwari
Network Security Consultant
Fujitsu Network Communications (Telecommunications, 1001-5000 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend

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.

May 08, 2019

DPA was the perfect choice

AV
Alexander Veitschegger
dba
3 Banken IT (Capital Markets, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
May 02, 2019

DPA - A simple and well-built SQL Tool to find Issues within your Databases!

Verified User
Employee in Information Technology
Retail Company, 5001-10,000 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
SolarWinds DPA Product has a fantastic small footprint and allows for any System Administrator or Database Administrator to easily find Queries that are taking excessive resources or time, which in turn can affect the product performance. Being able to retrospectively go back has proved to us many times that you don't have to wait up and run SQL Trace at 1AM to find out what query is causing issues!
May 02, 2019

SolarWinds - we understand the network better

Verified User
Manager in Information Technology
Accounting Company, 1001-5000 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Yes as described earlier we have had 2 major issues where we have used DPA to find out the root cause - this was very easy as it was the SP that was running particular SQL code that the DPA highlighted as top of the results because of its longest wait time.

March 22, 2019

DPA makes finding the cause of database problems almost too easy

Verified User
Contributor in Information Technology
Consumer Services Company, 201-500 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
DPA is very well suited for analyzing problem queries and showing the wait statistics associated with those queries. It makes it very easy to see how they have performed over time. Most of the other database monitoring applications focus on performance counters. DPA focuses on wait statistics. If you are looking for a performance counter-centric monitoring solution, then you will find DPA appealing.
Return to navigation