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-4 of 4)
Companies can't remove reviews or game the system. Here's why
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.
This is an easy 10 because I actually have recommended this product to multiple clients and colleagues! Any shop that writes its own SQL queries will benefit from the insight provided by SolarWinds Database Performance Analyzer, so they know which of their queries is causing a bottleneck. Small shops or databases with only a few tables likely will see far fewer opportunities for optimization.
  • Identifies objects causing bottleneck by real wait time
  • Identifies specific section of a large query that needs attention
  • Lets you see what index is actually being used
  • Helps you see if CPU, RAM or DISK is the limiting resource
  • View Plan Details is actually a bit weaker than SSMS because all the lines are the same width
  • The "View SQL Text" viewer could be fancier - but it does clearly identify the problem section
  • It is not uncommon to identify a query that is taking 70 seconds and reduce it to under a second. It sounds crazy, but it is true.
  • Improving a SQL bottleneck benefits more than just one specific use case! Overall responsiveness of the application improves.
Yes
SQL Database Engine Tuning Advisor is totally replaced. In theory, it is intended to provide the same type of insights but fails miserably.
  • Price
  • Product Features
  • Product Usability
  • Product Reputation
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.
SolarWinds Database Performance Analyzer (DPA) is great for monitoring Oracle and SQL databases for performance anomalies. When a user calls and says "It's slow" we have one [place] to go to review the data, zero on the problematic query and take action to resolve. In addition to being a great troubleshooting tool DPA also provides query tuning advice based on captured long-term analysis to spot inefficient patterns.
  • Database performance monitoring.
  • Database performance root cause analysis.
  • Server performance monitoring.
  • Licensing Model can be expensive on a per-instance basis, consider a per-host-based option.
  • Limited ability to combine monitoring results for similar groups of servers.
  • Different license types for different types of servers (Oracle Enterprise vs Standard).
  • One stop shop for all database performance data.
  • Faster time to resolution on database performance issues.
  • Ability to capture and analyze performance data.
DPA is a market leader and goes beyond what most products in the space can offer. It's a battle between SQL Sentry and DPA for the lead and everybody has their favorite. I personally prefer DPA for ease of install, management and better tuning and query advice options.
Yes
Oracle Enterprise Manager (OEM). We wanted a tool that supposed Oracle and SQL which OEM doesn't.
  • Product Features
  • Prior Experience with the Product
I had used DPA had a previously job after having it recommended by a DBA I trust. We started it using it and right away it became a popular tool both on our teams and with others.
  • QA Team troubleshoots performance issues from on new code prior to role out
  • Operations Team troubleshoots performance issues on production applications in real time
  • Dev team uses DPA as a resource to optimize existing code as we scale data
  • Security team can use it to identify out of band activity
  • Charts/Graphs go over great with non technical team members
  • Locate additional paid optimizations possibilities to our applications.
  • Increase efficiently of our code allowing us to scale in support of new data without expanding resource consumption
  • Increase Application Response SLA's due to improved code
We got it right.
Yes we purchased premium support to ensure we have the latest build of DPA and access to technical resources and training should we run into problem. We don't have to open tickets often but when we do it's usually a critical issue and we need support ASAP.
We use DPA in production and we want to have the latest version and access to support.
Good support, fast response, knowledgeable engineers, easy to access.
No
Numerous times usually with upgrades.
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.
  • We have set up alerts on long-running queries, blocking other queries, deadlocks, instance availability, unused indexes, etc.
  • The status summary is useful to see the load on the server.
  • Deadlocks alert can be improved to show what queries were in the deadlock, so we can improve our solution.
  • Deadlocks alert can be improved to show what queries were in the deadlock, so we can improve our solution.
  • We never got to setup https using the documentation provided by solar winds. We still keep getting https error when we access our DPA site.
  • A better technical customer service would help.
It is good to set up alerts on the database server. some of the alerts described in previous answers can be improved. Help on setup can be improved. As described earlier, we still do not have our DPA site set up with the security certificate and customer service did not help much.
  • It helps us monitor our server which is very useful.
We selected SolarWinds Database Performance Analyzer to be able to monitor our database server.
No
  • Price
  • Product Features
  • Product Usability
  • Product Reputation
  • Prior Experience with the Product
  • Vendor Reputation
  • Third-party Reviews
8
Database developers and architect
1
  • Query performance advice
  • long running query alerts
  • query blocking alerts
  • deadlock alerts
  • improve application performance
  • improve server availability
  • monitor data server performance and availability
We evaluated Redgate and Found solarwinds to be better
  • Implemented in-house
No
Change management was a minor issue with the implementation
  • enabling secure website posed some issues. Installation was smooth
Very satisfied
  • no training
yes. Very easy
We can configure alerts for what we want to monitor, Example Failed agent jobs, deadlocks, service down, long running queries etc.
yes. I have configured deadlock monitoring, service down, long running queries, blocking queries, agent job failures, query tuning advice. They are very useful.
No - we have not done any customization to the interface
Some - we have added small pieces of custom code
we have added custom code to monitor long running queries, blocking queries.
deadlock monitoring, service down, long running queries, blocking queries, agent job failures, query tuning advice
No
very good. Respond within a day
No
I was not able to enable secure website. The support helped me with that
  • monitoring memory usage
  • monitoring processor usage
  • query advice
  • certain reports are difficult to understand
very good
  • SQL server
We only monitor our SQL server database. pretty easy
  • network monitoring
  • Single Signon
Good tool. must have
support for the product to be included
vendor is pretty good, very responsive
Yes
yes, it went pretty smooth
  • new features like deadlock alerts,
  • new reports
  • deadlock alert
  • new usage reports
No
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
  • Not my area of expertise.
NA
No
  • Price
  • Product Usability
Selected for easy to use, logical and intuitive user interface.
Why is this survey missing the part about which other products were considered?
Would NOT change the product evaluation & selection process at my organization.
In my opinion, a better use of this third question in the survey would be to discuss which other products were considered, because the survey's lead remarks said this would be the focus.
Return to navigation