TrustRadius Insights
User-Friendly Interface: Users appreciate the SolarWinds Database Performance Analyzer for its straightforward and easy-to-understand …
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…
Recent 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
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?
27 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…
Product Details
- About
- Integrations
- Competitors
- Tech Details
- Downloadables
- FAQs
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
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
SolarWinds Database Performance Analyzer Videos
Azure Database Support Overview
Watch Product Overview
SolarWinds Database Performance Analyzer Integrations
- SolarWinds Server & Application Monitor
- SolarWinds Virtualization Manager (VMAN)
- SolarWinds Storage Resource Monitor (SRM)
- SolarWinds Network Performance Monitor (NPM)
- SolarWinds NetFlow Traffic Analyzer (NTA)
- SolarWinds Network Configuration Manager (NCM)
- SolarWinds IP Address Manager (IPAM)
- SolarWinds VoIP & Network Quality Manager (VNQM)
- SolarWinds Web Performance Monitor (WPM)
- SolarWinds User Device Tracker
SolarWinds Database Performance Analyzer Competitors
SolarWinds Database Performance Analyzer Technical Details
| Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Windows, AWS Marketplace app |
| Mobile Application | No |
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).
Comparisons
Compare with
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!
- Pros
- Cons
- Recommendations
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
(101-113 of 113)Companies can't remove reviews or game the system. Here's why
January 25, 2019
DPA - an esy to use and invaluable tool for a DBA or a software engineer professional.
We are actively monitoring our production and staging environment for any potential negative impact of new deployments or a performance impact due to a dramatic data growth.
- No agent required on a server, which allows us to easily switch a monitoring target.
- Integration with a VM Hosting software, so a correct decision could be made on sudden resource utilization spikes.
- Capturing a live execution plan for further analysis.
- Historical monitoring data is available for an extended time period.
- Increase a query name file size, so the names could be more meaningful and allow for distinguishing different versions of the same query easier.
- Would be nice to see captured parameters for a query, when the usual execution plan was changed.
- On the statistical/historical site: highlight rarely used indexes.
January 23, 2019
DPA within my organization.
AEO uses SolarWinds Database Performance Analyzer to maintain a better view of how key databases are performing. These databases are key in our overall business success so having the ability to see trends and be more proactive to possible issues has been key in our success.
- One use case was to use SolarWinds Database Performance Analyzer (DPA) to look at our overall SolarWinds Database as part of a POC. We were able to make changes in the database to increase the response of our SolarWinds system. It was this POC that made it known that we needed this type of tool.
- We used DPA to further help identify issues in key business databases to help improve the user experience.
- It would be nice to bring the detailed views we get when we go out to the SolarWinds Database Performance Analyzer server within the SolarWinds UI. This would help move us to the unicorn of a "single pane glass" view.
January 23, 2019
SolarWinds Database Performance Analyzer and how it freed us.
SolarWinds Database Performance Analyzer (DPA) is currently being used by one of the business departments to pinpoint and solve issues on certain client SQL instances.
- It quickly finds bottlenecks in queries and helps determine why the bottleneck exist.
- With DPA you can see via graphs the longest queries or the ones taking the most resources.
- DPA also integrates very well with SolarWinds Server and Application Monitor so it's easy to set up simple or advance alerts.
- SolarWinds DPA is truly an advanced tool so perhaps more training videos to match all the great documentation.
January 23, 2019
DPA worked for us.
SolarWinds Database Performance Analyzer is being used by our IT department to monitor and identify any bottlenecks in our database infrastructure.
- Visualizes the time taken to complete queries.
- Offers suggestions on how to tune queries.
- Alerts you when there is a potential issue.
- The interface could be improved.
- Make it more user-friendly, reduce the learning curve.
- Offer definitions for database terms on the page or within a tooltip.
January 23, 2019
SolarWinds DPA makes your day more than OK!
SolarWinds Database Performance Analyzer is used to identify possible issues related to performance, outages or develop improvements in both our own and vendor-provided solutions with SQL databases. Our internal development and support team can review the findings and recommendations from SolarWinds and report on any issues to staff and management. Our vendor can be provided reports on SQL performance of their product after version upgrades, design implications or outages with easy to read data and recommendations. The content being monitored impacts the entire organization so it is critical to our success that these tools function at their best at all times. We were incredibly fortunate to locate the SolarWinds DPA tool.
- Deep dive into reports, via logging, graphs and pop up tips from SolarWinds.
- Easy to install and customize, recommendations on findings are easy to understand.
- Easy to read interface and layout, little to no training required to become operational.
- I would like to see more granularity in administrative rights, although this is a very minor issue.
January 23, 2019
Try it out for smaller environments.
We are using SolarWinds Database Performance Analyzer (DPA) in our IT department. We have heavy analytics jobs that query RDS databases. DPA helps us to find queries taking longer execution times.
- Query issues on each database.
- Database engine metrics.
- Detailed status summary.
- I can't think of any.
January 22, 2019
More than Satisfied
The ability to monitor, in real time, some new database servers we purchased is key to making them as effective as possible. We also needed visibility into inefficiencies surrounding our existing servers. Having a system with email alerts, AD integration, at-a-glance holistic dashboard views, and resource monitoring were key, but DPA goes over and above with index and query recommendations, and integration with our existing Orion platform. Already having Orion meant the Database Performance Analyzer was sort of a no-brainer, but the features of DPA have proven that it's worth the money.
- Customizable Alerts
- At-A-Glance Categorized Statuses and Wait Time Trending
- Holistic Server/Application Monitoring using Orion
- Availability Group status monitoring could be a little more developed, and sometimes it doesn't report the correct primary replica until the page is refreshed.
- DPA reports on queries that may benefit from tuning, but it would be great if you could turn off the recommendations for specific databases, such as vendor application databases where procedures are not likely to be touched.
July 21, 2017
One of a kind
I have been looking to implement Solarwinds DPA for some time. It has been the only tool that can find performance issues in SQL code based upon waits. It is well worth the cost for that level of troubleshooting. By combining wait performance with historical execution plans, I can find what impact coding changes are making in the environment.
- Wait based performance analysis
- Historical execution plan comparison
- Integration with other Solarwinds products
- Minor pain points create difficulties in historical tracking.
April 06, 2017
Database performance monitoring made easy
SQL data is the core of our business. We provide very time-sensitive services for our clients using a combination of in-house and third party products and queries. We need to be able to quickly determine where the bottlenecks are and what is causing them. Database Performance Analyzer allows us to focus immediately on problem areas and gives us instant feedback on the impact of any query design changes.
- Setup is simple and you start getting meaningful data immediately.
- The interface is intuitive and it is easy to drill down into more specific detail. Every section has all the information you need on that page so you can see at a glance how everything correlates.
- The integration with other Solarwinds monitoring tools are especially helpful and gives you a much broader look at your entire environment.
- I have yet to find any data that I cannot see or any database related problem this has not helped resolve.
We use Solarwinds Database Performance Analyzer to monitor across all of our environments. All physical servers, virtualized, and cloud are being checked for any performance issues involving our SQL databases. Everyone in our team uses it and discusses the results in our weekly meetings. The alerts are used to escalate issues up to management.
- Performance monitoring
- Centralization of all servers and architecture
- Notifications whether by email or phone
- User friendly statistics
- Cloud support
- Lock alerting
April 12, 2016
Solarwinds DPA - Tools to help your DBA
We use Solarwinds Database Performance Analyzer to monitor 4 SQL Servers and over 300 databases. DPA allows us to see a holistic view of each server and then drill into problem databases or queries to see specifics. This has allowed us to identify problem queries before they can impact any other clients or the entire server. Daily reports and trend analysis helps us keep up our standards as the load increases.
- Trend Analysis for database server resources
- Deadlock detection and reporting
- Index recommendations
- Drilling down to individual queries inside of individual databases
- Alerting is cumbersome to set up
February 17, 2016
Great tool for long term query performance monitoring.
Up until last year, we were using for both operational and query performance. Today, we use it to monitor query performance and wait stats.
- There isn't a better tool for analyzing wait stats on a server.
- Very light weight when monitoring servers.
- Not a good operational monitoring tool, especially if going cross domain to untrusted domains.
- Disk resources are lacking ability to watch mount points and other disks without customization. This becomes challenging as the environment grows past 10-15 machines.
February 05, 2016
SolarWinds DPA for DBAs!!! Working Smarter, Not Harder!
We use it as a monitoring and troubleshooting tool as part of the Data team in out IT department. It helps us to identify real time performance issues as well as any unusual activity such as job failures, long running queries, blocking issues or failed SSRS subscriptions.
- Being able to analyze a query performance over time is a great asset. It helps us to identify certain bottlenecks or issues that occur during certain points in time and compare it to a baseline that tells us if there is an issue.
- The alerts that you are able to generate are also a huge help. they have a lot of great predefined alerts for general issues, but the ability to create your own alerts is a huge benefit.
- DPA allows you to drill directly to poor performing queries that the tool has identified and allows you to see all the important metrics in one screen. Being able to see the number of executions, memory and CPU consumed along with blocking allows you to identify and correct poor performing queries much more efficiently and reduces research time.
- It would be nice to have a separate dashboard that allows to see job performances over time (trends and summary)
- It would be nice to have a separate dashboard that allows us to create traces on the fly based on findings from DPA
- It would be nice to have a way capture parameter values passed to procs during a time period or that failed or returned an error.