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?
28 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
(26-50 of 113)Companies can't remove reviews or game the system. Here's why
July 20, 2020
SolarWinds DPA is a great tool
Solarwinds is used by our department to identify performance issues with our system using a Sybase database.
- Measures wait times of queries performed on our Sybase database
- Displays the current queries being performed on the database
- Displays, in a user friendly display, the status of the database
- Searching for specific users
- Examining which processor is running which query at the time
DPA is currently used by our development and support team to monitor our core database to keep an eye on performance day to day to avoid any rogue queries or new application causing issues for our business as a whole. In the early days of our business platform it was used to refine our queries to provide a better user experience.
- Highlights abnormal query performance
- Provides historical base line
- Gives detailed insight and these days recommendations on how to improve performance
- Not be written in JAVA and run on Apache
- Upgrades are always a problem for us
July 17, 2020
DPA: The Advance DBA Tool
Our SQL server performance monitoring is done by using DPA SolarWinds. It's used in our department only.
- Details query capture with the plan and resource utilization.
- DPA backend is an SQL server that you can control by performing some operations from the backend like change in retention, etc.
- Supports latest SQL features like AG.
- Report features are very good
- License management. DPA is not able to sync licenses and needs you to manually reconcile every time.
July 17, 2020
Great for general monitoring
Solarwinds Database Performance Analyzer is being used to monitor for issues with our SQL Servers by our organization. We use it to provide a baseline and display opportunities for improvement. The tuning feature helps us find bottlenecks and provide index suggestions. Our software development department uses the tool to show how the code has affected database performance. The network operations department monitors the data to find areas that may need upgraded hardware or configuration changes.
- Displaying baselines helps to show management how a change has affected performance positively or negatively.
- The tuning feature is helpful in showing areas that could be improved with an index or code updates.
- Wait statistics information is very helpful to diagnose database bottlenecks.
- Naming the hash takes more steps then it did in the past.
- It would be nice if there was a way to group the wait statistics by procedure.
- I search feature would be helpful.
July 17, 2020
DPA Pros and Cons
We use this product to diagnose and maintain the good performance of SQL Servers. We find degradation or lag, and it also helps issues with queries to be addressed.
- Query Analyzer
- HA Status
- DAG HA Analyzer
- Custom Time Windows for history
July 14, 2020
Key to knowing true DB performance
It is used in IT to monitor database performance and to assist with troubleshooting when there are performance issues with key applications. It is primarily used by our Database Administrators and has assisted in maintaining key performance metrics. It has allowed us to be proactive in our approach to performance monitoring and being able to resolve problems before they affect users.
- Monitoring DB performance
- Insight into hard hitting queries or jobs
- Visual representation
- Can be better in presentation of issues
- Would be good if it could provide possible causes or solutions
July 14, 2020
DPA in Govenment
The database team uses DPA to manage up to 50 licenses. Only 5 team members who are DBAs actively use the tool. All SQL performance problems from large PeopleSoft DBS to Cots applications (500+) are covered. Performance problems can come from all directions so this tool is extremely useful because it's a catch-all.
- Peoplesoft DBs: we often use it to recommend indexes or find queries that need tuning.
- Availability group monitors and alerts so we know when there are problems.
- Trends over time: like blocking, deadlocks or stuck queries DPA helps pinpoint the cause.
- Bug with fantom availability group.
April 19, 2020
Keep an eye on your databases using Solarwinds DPA
A database should be more optimized to run faster and efficiently. SolarWinds Database Performance Analyzer is one of the best applications which is used as a management and performance monitoring solution for any database. This software is straightforward to use and configure. And it is user-friendly. In our organization, we are using SolarWinds Database Performance Analyzer to manage database performance issues such as errors, long-running queries and more.
- The interface of the SolarWinds Database Performance Analyzer is straightforward. And it is easy to understand also.
- SolarWinds Database Performance Analyzer helps to immediately identify the performance problems of SQL Databases such as errors, long-running queries or issues that are blocking the system.
- It provides real-time analysis and support. Also, it can review issues from a historical point of view.
- Many databases are supported.
- The cost of acquiring this software is bit expensive. But it's absolutely worth.
- It takes considerable time to load.
- The reporting feature should be improved.
As an organization that relies on data and databases, it is important that we have the right tools in place to ensure our data is always accessible. The technology team has set up SolarWinds Database Performance Analyzer to monitor all of the critical databases on our network to ensure 100% uptime. SolarWinds Database Performance Analyzer allows our technology team to focus on other issues and only deal with the SQL servers when SolarWinds Database Performance Analyzer alerts the team to any potential issue.
- Analyzes performance trends with all of the databases
- Analyzes memory, CPU, and disk space on the SQL servers and alerts on any potential issues
- Provides stats on wait times by database
- Offers tuning suggestions on how to improve the performance of under-performing databases and queries
- query and index suggestions are not straight forward. you need to understand sql in order to interpret and use the suggestions properly
- if you have a lot of databases, the price could inhibit the implementation
- not all reported issues have suggested fixes
March 29, 2020
SolarWinds Database Performance Analyzer as a whole
Database Performance Analyzer is really helpful in our organization to find DB issues. It does in-depth database performance monitoring and provides a lot of valuable data to us.
- Database Performance Analyzer module helped us capture database response times and other info.
- Database Performance Analyzer is really good at capturing in depth DB data that is not really possible from multiple other modules.
- Investigating everything is manual in SolarWinds Database Performance Analyzer.
- We will need to manually figure out what the issues are using SolarWinds.
March 17, 2020
SolarWinds Database Performance Analyzer Review
Currently, our DBOps and SysOps teams use SolarWinds Database Performance Analyzer. Both teams use it to analyze our database clusters and individual databases.
- Shows performance issues
- Displays blocking
- NA
February 27, 2020
Real ROI that added a 9 to our uptime.
Our business lines span many industries and have a vast array of projects in production. Many of the environments we have must be segregated, and SolarWinds Database Performance Analyzer offers us a clear, detailed view of these environments through a single pane. Our DBAs can more quickly address issues and quickly settle the "hardware versus software" debate between engineers and developers.
- Alerts us of current issues affecting system performance
- Alerts us of potential issues that will affect system performance
- The licensing timeline needs improvement. Adding new instances becomes cost-prohibitive at some times of the year due to the locked-down renewal period.
February 27, 2020
SolarWinds Database Performance Analyzer Review
SolarWinds Database Performance Analyzer is used by our database and applications team to ensure the application code is working as expected, as well as to monitor database performance.
- Reliability
- Accuracy
- NA
- NA
February 07, 2020
SolarWinds DPA review
The SolarWinds DPA module is used mainly to monitor our MSSQL instances for performance. We had lots of issues related to DB performance and we were not sure about the root cause before implementing DPA. Now, we are getting proactive alerts when there is a deviation from the performance baseline configured in the tool and we are very happy with it.
- Easy to configure
- Real time data
- Notification email templates need improvement
- Needs a little training to go over/work with dashboards
January 29, 2020
Just works!
We have been using the database analyzer to monitor any changes that have occurred or any issues currently prompting. It has helped when looking at the trends around the flow of information and possible connection issues. We use it on a regular basis within two of the main departments. It is a great product.
- Analyzing data flows.
- Connection issues clarified.
- Would love a bolder UI font.
January 24, 2020
DPA user
It is used for database performance monitoring. It has helped us in addressing slow queries and other resource issues.
- Highlights slow queries.
- Drill down options to the second for troubleshooting.
- Better suggestions for indexes.
January 15, 2020
One of the BEST at-a-glance database monitoring tools out there.
It is being used to monitor all production instances for the whole organization.
- Provides meaningful status at a glance.
- Highly configurable alerts (less spam/noise).
- Could allow better tuning for summary page information. Sometimes data is a bit stale.
- Could use better database level summary information in addition to server/instance level.
December 04, 2019
Invaluable, Trusted Performance Diagnostics
DPA is an essential part of performance monitoring our hybrid Demand Management Solution for hosted customers, and select on-premise customers. Automation is essential considering the number of customers, the schema comprising approaching 3,000 tables and over 5,000 code artifacts. Daily summaries of the last 3 days of Top SQL resource consumers give us ongoing snapshots by which to spot trends and anomalies that DPA's functionality enables us to investigate to query and table level.
- Automated Collection into a queryable repository - Hands-off, detailed collection assures us that the bulk of any performance issues are noted, so that their data can be presented on-demand in a readily consumable form. Drill-into features enable detailed analysis.
- Performance Trend Analysis - Monthly top-consumers visualized in meaningful stacked-charts, with anomaly highlights and per-query, per-day detail enables hot-spot drill-down analysis.
- Resource Utilization Warnings - Best-practice warning and critical measure applied to all facets, visualized in real-time are essential features that trigger troubleshooting.
- Usability within the Trends and Current pages need improvement - Version 11 introduced a new Tuning feature, and changed the way one could quickly name a query and chose whether it would be of further interest, or is more infrastructure-oriented such that exclusion is warranted. Usability took a downward slide.
- Resource Utilization has preset periods which, for longer durations, overly smooth charts. Custom periods are much needed via the UI, rather than repository-querying.
- Storage analysis, similar to resource usage, needs custom periods and far greater ability to delineate between drives and files than v11 currently offers. (One rarely uses the Storage I/O tab)
November 24, 2019
Would be lost without it
Used to monitor production database performance and identify areas for tuning.
- Allows instant identification of highest impact performance issues
- Provides visibility of database load across the application
- Easy to configure and use
- It's a great product. I really can't identify any cons.
November 20, 2019
Solarwinds DPA gives your non-DBAs the ability to look inside and diagnose database problems!
We use Solarwinds Database Performance Analyser across several teams in and around the IT department. It's used to pinpoint issues with databases or SQL statements, generally on production databases. While Solarwinds Database Performance Analyser won't tell you anything that a real live DBA wouldn't be able to find out, it does allow non-DBAs like myself to get an initial problem diagnosis quite quickly and suggest to the relevant teams where they should be looking to resolve the problem.
- Pinpoints potential issues with databases.
- Suggests remediation for these problems.
- Allows you to narrow down to particular points in time where the problems were observed.
- It does take a while to gather enough data to suggest problems and fixes. Generally speaking, while you'll get some data back in an hour or two, you want at least 2 days of monitoring to get the best results.
- Licensing is a bit restrictive.
- Switching licenses between monitored nodes is a bit annoying.
Discovering data performance issues. Creating an index based on the suggestions by DPA. It can be accessed by all developers to review their query or performance-related issues.
- Suggest indexes.
- Indicate the wait time for all processes, so you rank the issues and fix them by priority.
- You can send URL/ links to other to show them the exact point of problem. Easy for collaboration.
- Bookmark of problem, so we can revisit the issue and compare it before and after the changes.
- More details on deadlocks/blocking, etc.
- Notification, kind of monitoring, if wait time exceeds some threshold.. or review the wait time of specific bookmarks or issues.
September 26, 2019
Best Database Performance Tool
We use it to monitor and performance-tune some of our in-house developed applications. Some of these applications are tier-one applications.
- Track historical performance.
- Isolate the issue by providing a specific area of query impacting performance.
- Can track which user is causing the issue.
- Provides quick indexes where it makes sense.
- Auto tuning - It doesn't have the ability to implement the changes like Oracle Enterprise Manager.
- DPA free version is good but fully functional version should be allowed free for a limited number of instances to give users the ability to try functions without a need to make a purchase.
August 02, 2019
Small Teams use of DPA
DPA is being used by the IT and CIM Developers team to monitor our production databases. IT will check the system daily for any signs of issues. Both teams will check when testing or rolling out new systems to ensure the Software is operating as intended. These testing checks are done at least once a week by either department.
- Quickly identifies slow running queries.
- Identifies which database is causing issues on a server.
- Provides an easy to read way of seeing stats on all servers quickly.
- No way to mark a query activity as normal, for example a slow running SPROC that has to be that way.
- Not many options to restrict access.
July 30, 2019
SolarWinds at a large bank as seen from an Engineer
Within our organisation, we use SolarWinds to monitor the most important applications. We give permissions to our customers to view their own data. DPA is saving us on logging in on servers and telling the customer to modify their application (they can see it themselves and fix it themselves). Also it gives us background information on the Virtualization layer and their isseus. It is really helpfull as a first responder to a customer with performance questions.
- monitor databases
- monitor servers
- monitor on virtualisation isseus.
- adding permissions for users or domain groups
- adding boxes is not easy
- being able to remove servers after x month (automagically or via an API)
July 27, 2019
Solar Winds DPA provides the best trend charts
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.