SolarWinds Database Performance Analyzer

SolarWinds Database Performance Analyzer Reviews

Top Rated
TRUE

Do you work for this company? Learn how we help vendors

Reviews
(1-25 of 107)

Companies can't remove reviews or game the system. Here's why
Mike Saedi | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • Excellent for trending SQL Performance over time.
  • Excellent for monitoring deadlocks and blocking.
  • Good for trending SQL query changes over time.
  • It would be nice to have more built-in alerting capabilities.
  • Indexing recommendations are also somewhat unclear. I have seen areas that say you could improve performance on a table for example but not giving any additional details beyond that.
  • More in-depth recommendations, other tools like Idera Diagnostic Manager I feel are stronger in this area.
I like the fact that I can visually see what my SQL server is doing over time and drill into top queries.
Alerting and notifications are not as strong as some other tools I have used.
Blocking and deadlocking features/analysis could be improved also.
We had an issue recently where we experienced poor performance of a query due to a plan change. DPA pointed this out and I adjusted how often I updated my statistics, which helped this query. I would have a hard time knowing that the query plan change was the root cause of the issue had DPA not told me.
One thing that might be helpful though would be if DPA saw this plan change and then told me I should update my statistics, since I had to figure this out and do this separately on my own.
Nikhil Kumar Sharma | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • Multi Vendor Databases Monitoring
  • Agentless Monitoring
  • Less Dependency on DB Admins
  • Less Resources consumption on target databases
  • API based integrations
  • Cloud Database Monitoring such as Google native SQL service
  • Modern (no SQL ) database monitoring
  • Dashboard Flexibility
  • Reporting Flexibility
Solarwinds Database Performance Analyzer is well suited in below Scenarios -
1. End to End Database Instance Monitoring.
2. Database in Clusters Monitoring such as Availability Group in MS SQL, CDB in Oracle etc
3. If you want detailed monitoring with historical analysis.
4. SQL Statement Deep Dive Analysis for WAIT Time reason, Blockers, Deadlocks etc


Solarwinds DPA is not well suited if you are looking for Detailed VM, OS monitoring where Database is installed.
I can share one good example we recently came across where there was a huge downtime happen for a Business Application and Application team were not sure what might be causing this but DPA immediately helped us to find the root cause. Issue was with the transaction logs of the database which got full and hence no further transactions were allowed to happen due to which application got stopped, application team looked at DPA console and found the root cause immediately.
Joseph Dixon | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • Insight into query wait times
  • Ability to view Disk IO
  • Historical trending of wait times
  • Dated UI
  • Development servers are not free
  • Dashboard visualization of stats requires Solarwinds Performance Monitor (Included with Orion)
SolarWinds Database Performance Analyzer may have a dated UI, but don't let that deter you as what it really does well is give you the data you need to find issues and resolve them with your SQL Servers. It can also do Oracle and other platforms as well. Your servers being on the cloud is NOT a problem at all and we have full visibility into our Google Cloud database instances as well as our on-prem instances within the same pane of glass. If you have MySQL or PostgreSQL you might look into Solarwinds Database Performance Monitor instead, unless you have a mixture of both and want everything in one spot.
One thing to note is that you will need to host DPA yourself, it's not a cloud solution (although you can host it in the cloud if you prefer). This also means you have complete control over where this data resides.
We were having an issue where our check-in system was causing slowdown on SQL server. We were able to root cause the issue to some individual queries that were being generated by Entity Framework and work with the developer to rework the EF code to generate queries that were much more performant. This resulted in a significant decrease in the amount of CPU wait time we were experiencing and prevented us from needing to increase our server sizes to the next CPU tier.
We have not needed to use support that much, but every time we do they are professional and courteous as well as responding within an expected timeframe.
Score 7 out of 10
Vetted Review
Verified User
Review Source
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..
  • It allows us to have a gateway to the databases that the users would not normally have access to.
  • It allows the database admins to not have to provide analysis as users can do their own through the interface.
  • It's a quick place to do an initial view into performance issues for DBA.
  • Would be nice to have more granular permissions.
It's well suited as a self help tool. It really saves time on our team so we don't have to provide guidance on issues or questions.
We have had a fair number of performance issues with new developers who are not experienced with sql coding. That way they can log into DPA and review their own performance times, or index hits based on the data they can see.
Score 10 out of 10
Vetted Review
Verified User
Review Source
[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.
  • Maintains historical SQL execution data, enabling forensic analysis
  • Has the ability to slice and dice the data so that you can drill down to the execution of a single SQL statement being executed by a stored procedure
  • Alerts to when the consumption pattern changes
  • Shows historical average run times against the current, illustrating problems when they arise
  • Provides tuning advice based on best practices
  • Everything is displayed visually, if you need detailed metrics, you have to extract manually, it could use a report writer with export to Excel.
  • When a SQL statement is very long running, i.e. longer than the display interval, the display says that there are no statistics, it should on the other hand, show that the SQL statement is still running.
  • When you name a SQL statement, it should be by DB, rather than global
Very appropriate for use in performance testing
Very appropriate for alerting to performance issues before they become critical
Can be challenging when monitoring an Oracle active-active RAC database, as each instance is effectively a separate database.
We were running a bulk update in a package application, with abysmal performance, i.e. hours instead of seconds. The vendor was focusing on the UPDATE statements. Using DPA, we were able to show that it was actually the SELECT statements causing the problems and that the UPDATE statements were actually running in milliseconds while the SELECT statements were running for hours, due to full table scans on both sides of a nested loop.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • Speed
  • Ease of Use
  • Appearance
  • Detail
  • Setting up alerts and blackouts could use improvement
  • Should be able to flip between SQL ID and hash plan for queries
  • Some queries that run on the database instances themselves could use tuning
[SolarWinds Database Performance Analyzer is] well suited for historical performance metrics. Well suited for alerting based on custom queries. Not well suited for real-time metrics or session-level debugging.
Multiple instances come to mind; when other tools in our environment do not have the metrics, we turn to DPA for historical query information to trend performance over time. DPA is superb when it comes to trending and charts.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • Analyzing query performance
  • Index recommendation
  • Wait time categorization and explanation
  • Navigation is generally good, but some items can be confusing to find again
The product works incredibly well when trying to understand blocking and overall performance issues. It produces minimal load on the database server and provides a wealth of information. After you use the product to assist with urgent performance issues, it then alerts you to trends on your database server that may require your attention. By review these trends and adding indexes or modifying query patterns, you can substantially improve the performance and reduce the resources needed to running your database server. The software does require someone that understands query performance and optimization -- by no means does it do all of the work for you - but it does offer suggestions that are typically viable and worthwhile.
We knew that we had an issue with disk performance and were intending to move to provisioned IOPS to resolve the problem using Amazon AWS. We used SolarWinds Database Performance Analyzer to understand the issues further and found that a series of extremely quick queries were running from a legacy process which ultimately performance millions of table scans per hour. By optimizing this process in just a few minutes, we were able to avoid the need to further scale our SQL environment. This type of issue would typically be invisible - quick queries don't stand out like a sore thumb, but they can have tremendous impact.
The one time I contacted support, they were easy to speak to and resolved my question quickly.
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • Tuning
  • Deadlock issues
  • Blocking
  • Alerts
  • Reports
  • Performance tuning
  • Graphical representation of SQL agent jobs
  • Easy to create any graphs by adding tables or columns
  • Change the home page for more options
  • Best possible recommendations
If your operation is data driven, then you need to improve performance where SolarWinds Database Performance Analyzer helps. It is helpful if you have a big environment where your databases are dependent on timely fixes. It can also be used for resolving application deadlocks and the health of the database--also setting up alerts and adding more custom graphs.
Using SolarWinds Database Performance Analyzer is probably most helpful with deadlocks, as it pinpoints where the issue is and helps to remediate that for the future. Alerts further sends you email about a deadlock so you can be two steps ahead of others and fix it before users complain. You can create historic reports which, is also helpful for mitigating future issues.
Score 10 out of 10
Vetted Review
Verified User
Review Source
This is good tool to analyze the DB performance. This is used by DBAs to understand the usage of the databases across the departments. It helps in understanding the actual problem and resolve it.
  • Query analysis
  • Resource usage
  • Index advice
  • More advice
  • Backup details
  • Notifications
If you have high transactional database then this is very useful [for] getting resource usage information and understanding the usage of the databases. Wait time graphs helps us understand the database bottlenecks.
Query was taking time and application was down
They are very supportive
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
Solarwinds Database Performance Analyzer is well suited for general monitoring. If you are interested in overall trends and issues that have a significant affect on performance, then this tool works well. It is less appropriate for deep dives into specific issues. When trying to monitor new changes, the impact must be big enough to display a difference in the charts.
A new procedure was introduced to make things more efficient. After it was deployed, the performance got worse. Solarwinds Database Performance Analyzer showed that a new index was needed and it would improve performance. After utilizing the advice, we realized the efficiencies with the new procedure.
July 14, 2020

DPA in Govenment

Pat Groce | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
I find the number of databases we support is high compared to the staff DBAs available. The DPA product is a good product here. If you had just a couple of databases it wouldn't be necessary.
Aruna Bandara | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
SolarWinds Database Performance Analyzer can smoothly work with different databases such as MS SQL Server, Oracle database and more. Also, it supports physical, virtual, cloud, etc.
We had some issues related to databases such as slow queries and data losses. Using SolarWinds Database Performance Analyzer, we were able to identify problems related to our databases, and now they are running without problems.
Score 7 out of 10
Vetted Review
Verified User
Review Source
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.
Database Performance Analyzer is really helpful for capturing DB procs and other info. However, it was not able to capture the data we needed like the application jobs running on the database, etc.
We had an issue where databases were going to a hinge state, and using Database Performance Analyzer we were able to find the jobs that were responsible for that.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • Automatically emails me weekly reports so I can keep an eye on our database performance.
  • Easily identify problem queries.
  • Helps us optimized our code.
  • The initial learning curve is a little steep.
  • A better explanation of the features would be nice.
  • Navigation is sometimes a little tough.
It's very helpful to have the robust reporting features available when you have a mission-critical database. We need to be aware of what is happening on our server and be able to tune and adjust as required to keep things running fast and smooth. SolarWinds DPA allows us to do this.
We recently released a new build of our in-house software. We were experiencing very high utilization on our database server which essentially stopped all critical usage in our database. Using SolarWinds Database Performance Analyzer, we were quickly able to figure out exactly what query was causing the issue and resolve the problem much faster then we would have been able to without SolarWinds.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • Anomaly detection powered by machine learning - new in version 12, greatly love that statistical analysis
  • Compare workload versus past on daily basis and total, it really helps us to see big picture of growth and make capacity considerations
  • Intuitive performance analysis - easyly examine the problems and find the root cause
  • In the last two versions 12.0 and 12.1 SolarWinds has made great enhancements. I do not have a thing that I currently want to be changed. There are some cosmetics in the user interface but do not think that they are problems.
I think it is well suited for mission-critical databases where every percent performance is a must. Maybe it would do great work in a data warehouse too, especially in detecting performance loss in ETL jobs. Actually, I think it is well-suited in all the use cases, if you have enough licenses :).
I cannot share an example due to regulatory restriction.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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 balance the load and find queries that need optimization.
  • no training
very good. Respond within a day
Yes
yes, it went pretty smooth
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • Immediate bottlenecks on the database tier.
  • Performance tuning.
  • Historical reports.
  • More details around the specific alerts which are raised on the console should be considered.
  • More information from a host layer monitoring could be handy as well.
  • A single layout for the report for all the different instances of DPA would be really handy. It is just tedious to go granular for all the instances across the landscape.
Very intuitive and easy for operations organizations to ensure that any symptoms which could lead to performance concerns on the database tier can be easily identified and looked at.
To ensure these issues can be given highest priority as and when any performance bottlenecks arise, the simple layout provided with the tool is really effective.
We had some customer promotions going on and the database was suffering from blocking sessions a lot during these promotions. DPA helped to pick these quickly and these were raised with the concerned teams to ensure that this can be handled well in time to ensure minimal impact to the business.
Score 9 out of 10
Vetted Review
Verified User
Review Source
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
The historical record aspect to view performance over time is invaluable, to be able to go back and see when things change which can then be related to application changes is great. Additionally, the live reporting current detail is brilliant for out of the blue and immediate issues that have to be dealt with.
We have a windows service that calls the DB for an action. If the action wasn't to be performed it was supposed to go to sleep and wait for a few minutes before trying again. However with a mistake in the code the procedure it called ended up being called every tick which lead to 1000s of executions per minute. DPA wait time status highlighted this within no time which lead immediately to the root cause, including snippets of the SQL text, allowing this to be resolved within minutes of becoming aware of it (and more importantly before any complaints that the system was running "slow")!
I have had to use their support on a few occasions, for reasons that I am not clear about until recently I have always had problems upgrading the software (although the last 2 updates have gone without issue which I am very pleased to say).

On those unfortunate occasions, the support has been brilliant with either excellently documented guides on how to resolve the issue by myself or have been hands-on with calls and screen sharing to remotely fix the issue. Every time the problem was sorted and more importantly, nothing was lost (apart from a bit of time). And as I stated above whatever the problem was that was causing my upgrade issues appears to have been resolved in the last 2 updates.
July 17, 2020

DPA Pros and Cons

Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
Very good at query help and resource information. Not so good at DAG HA designs. We have a DAG setup and SolarWinds DPA can not even see the local HA if this is setup. That is kind of a bummer since we need the HA information and DAG is an older tech.
  • Query Analyzer
  • HA Status
  • DAG HA Analyzer
  • Custom Time Windows for history
When root cause performance hits through the resources tool, we then correlate that to the queries that were blocking or had waits. It is very useful to have specific times and details to find underlying issues. Then we can use the query help tool that offers suggestions to tune the queries that may help avoid this in the future.
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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).
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.
We have a web based application running on Oracle that began experiencing daily performance issues every morning. We were able to quickly review query historical Top SQL Statements from the impacted time periods and identify a problematic query. As a short term fix we disabled the job running the query. Using tuning advice also provided in DPA we were able to improve the query causing the issue for a permanent fix.
Good support, fast response, knowledgeable engineers, easy to access.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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
Recommended overall for database operations and management. The tool is key and has played a good role in providing key information for troubleshooting. It can, at times, present information in a way that can be confusing. But, the application is also very useful for maintaining application-specific metrics that can be used in SLAs and performance metrics.
In troubleshooting a key application, it was able to highlight a query that had a heavy impact and cost on the performance that significantly affected users' ability to utilize the application. It allowed us to rebuild the query and schedule it for a different time where it was less impactful on user performance. This resulted in significant improvement in user surveys regarding performance.
Score 9 out of 10
Vetted Review
Verified User
Review Source
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
SolarWinds Database Performance Analyzer is great for any company that uses some form of SQL server in their environment. Whether it's Microsoft SQL Server, Oracle, Sybase, etc, SolarWinds Database Performance Analyzer provides insight into your environment's health.
In order to fully utilize and appreciate SolarWinds Database Performance Analyzer, I do recommend you have some experience with SQL queries and databases, as some of the suggestions and issues that could arise needs to be fully understood prior to implementing the suggested fixes.
Our organization relies on data and databases for most of our applications. We had one application that always took a long time to do specific reports and queries. When we put in SolarWinds Database Performance Analyzer, we set up some of our most critical databases first. After a few days, SolarWinds Database Performance Analyzer reported severe wait times on the one database we were having issues with. SolarWinds Database Performance Analyzer recommended some new indexes, and, after we verified and created the recommended indexes, the application and database performance significantly increased.
Score 9 out of 10
Vetted Review
Verified User
Review Source
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 really good at displaying real time performance issues.
DPA helped us demonstrate to our vendor that the majority of a wait time for a query was due to a badly formed SQL statement.
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
Well suited as an SQL server execution plan analyzer. Also, provides advice on the tunning part.

Alerting and reporting is also good features.
In multiple performances issues logical reads , execution count and execution plan helps in tuning queries and comparing results after tuning. Before and after query performance details on same graph is very usey
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
In an environment where many developers and DBAs are often working separately from each other on some projects and together on others, it gets difficult to see where the lines are between applications and databases. SolarWinds Database Performance Analyzer allows me as a manager to pinpoint issues and to get our developers or DBAs involved as appropriate to resolve issues that happen, and address issues that haven't happened yet. SolarWinds Database Performance Analyzer is worth a whole 9 of uptime in and of itself.
One instance where SolarWinds Database Performance Analyzer saves us is cost savings. We are able to see what inefficient stored procedures do to the resources we pay monthly for. We saw the need to pull a couple of developers off a project and have them concentrate on optimization and indexes, and we were able to reduce resource consumption enough to hire more developers.

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

DashboardAlerts and reportsApplication-centric view of DPABlocking deadlock analysisCollaboration across teamsIntuitive performance monitoringPerformance intelligenceQuery performance analysisReal-time & historic monitoringRecommendations

SolarWinds Database Performance Analyzer Videos

Azure Database Support Overview

Watch Product Overview

SolarWinds Database Performance Analyzer Downloadables

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 Pricing

SolarWinds Database Performance Analyzer Technical Details

Deployment TypesOn-premise, SaaS
Operating SystemsWindows, AWS Marketplace app
Mobile ApplicationNo

Frequently Asked Questions

What is SolarWinds Database Performance Analyzer's best feature?

Reviewers rate Support Rating highest, with a score of 9.4.

Who uses SolarWinds Database Performance Analyzer?

The most common users of SolarWinds Database Performance Analyzer are from Enterprises and the Information Technology & Services industry.