TrustRadius
Solarwinds Database Performance Analyzer presents a database performance and development solution.https://media.trustradius.com/product-logos/Gg/Bs/POP0NKN189DG.JPEGSolarwinds DPA: Quickly Identify Production Performance ProblemsSolarwinds Database Performance Analyzer (DPA) is a powerful database performance analyzer tool that is vital to our business. It is utilized by the organization to monitor hundreds of SQL Server instances that support customer businesses. The graphs and dashboards provided by the tool grant us the quick visibility into potential performance culprits that could be impacting our customers.,Solarwinds DPA provides easy to ready graphs to identify database performance problems. Solarwinds DPA displays vital Availability Group health information. This is used to quickly identify the status of SQL Server Availability Groups. Solarwinds DPA provides a drill down capability to see current and recent activity that may be impacting performance. This easy to use interfaces is vital to quickly identifying performance problems for improved up time.,Solarwinds DPA does a great job of analyzing commonly executed queries on SQL instances. The one thing it does not do well is gathering metrics and bubbling up ad hoc queries that may only run once and a while, or perhaps queries that supply a variety of parameters. This typically causes DPA to interpret commonly run queries with varying parameters as different queries.,10,This tool drastically cuts down the time it takes to identify production impacting performance issues. This result improves the system up time to our customers, which in turn enables them to better serve their customers.,This tool is used on a daily basis to identify queries with the highest wait times. This information is then taken back to our development teams to improve upon the said stored procedures. With this tool, we are easily able to identify whether the wait time of the stored procedure improved, by comparing the before and after performance metrics within DPA.,Yes, we have been able to use this information to identify tuning opportunities. This includes potential indexes that may improve the performance of queries that hit that table. The tuning recommendations are reviewed and tested prior to production implementation.,N/A,20,2,Monitoring database wait times across the previous month to find regressed queries or schema changes that may effect performance. Reviewing index recommendations. Getting a quick glance look at resource utilization for things such as CPU utilization, page life expectancy, read and write latency, and blocking sessions.,10,Navigating to the trends and resources tabs for a particular instance is easy to use and provides a great deal of information. Solarwinds allows for support to quickly identify performance impacting queries/procs.,The GUI does take some time to learn as there is so much information and detail provided. But the learning curve is short and the tutorial videos provided do help speed up the learning time.,10SolarWinds 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.,10,Increased customer service Reduced time in identifying issues Increased application efficiency,SQL Sentry and Redgate SQL Monitor,SQL Server Integration Services, Microsoft SQL Server, Visual Studio.NET,4,2,Monitoring Troubleshooting Optimizing,We used it to identify a WebService that went wild and were able to contact our partner and correct the issue in minutes, rather than hours,I can't think of any additional ways other than monitoring, troubleshooting and optimizing queries,10,The top SQL waits The drilldown into days and hours The query execution analysis,The custom ranges for each of the metrics The alert set up licensing,9
Windows, AWS Marketplace app
SolarWinds Database Performance Analyzer
146 Ratings
Score 8.3 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

SolarWinds Database Performance Analyzer Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
SolarWinds Database Performance Analyzer
146 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101

Do you work for this company? Manage this listing

Show Filters 
Hide Filters 
Showing 2 of 147 SolarWinds Database Performance Analyzer ratings and reviews.
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-2 of 2)

Do you use this product? Write a Review
No photo available
February 01, 2019

Solarwinds DPA: Quickly Identify Production Performance Problems

Score 10 out of 10
Vetted Review
Verified User
Review Source

Usability

10
I have used the product for 3 years now and realize that at first it took me a month or two to identify all of the information that DPA has to offer. Since then I use the tool on a daily basis for troubleshooting, schema change performance validation, index tuning and recommendations, and reviewing the overall health and wait times of the SQL instances.
Read this authenticated review

SolarWinds Database Performance Analyzer Scorecard Summary

About SolarWinds Database Performance Analyzer

SolarWinds Database Performance Analyzer (DPA) will enable you with deep visibility into database performance and expert advice for performance optimization and tuning

What can you monitor with DPA?
  • SQL Server (including Azure SQL DB)
  • Oracle MySQL
  • DB2 (LUW)
  • SAP
  • ASE (formerly Sybase)
  • 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 tracked in real time and historically
  • Find inefficient workload, aggregated by table, for indexing opportunities—an “X marks the spot” tuning analysis
  • Multi-vendor relational database support for your database environment in a single tool
  • Blocking analysis: what is blocking and a hierarchy of what is being blocked, plus overall impact
  • Integration with other SolarWinds products for more complete visibility (applications, servers, storage, hypervisor, network, and more)
  • Quick, easy, and low-effort installation, configuration, and administration

SolarWinds Database Performance Analyzer Features

Has featureDatabase monitoring
Has featureTuning advisors for queries, workload, and indexes aggregated at the table level
Has featureCorrelated resource metrics for easy diagnosis of hardware constraint impacts on end-users
Has featureDetailed blocking analysis for contention bottlenecks
Has featureI/O activity tracking at the drive/mount and file level
Has featureAlerts and reports
Has featureDPA Central to manage large and/or distributed environments
Has featureAlways On Availability Group and RAC insights

SolarWinds Database Performance Analyzer Screenshots

SolarWinds Database Performance Analyzer Video

Database Performance Analyzer - Overview

SolarWinds Database Performance Analyzer Downloadables

SolarWinds Database Performance Analyzer Integrations

SolarWinds Database Performance Analyzer Competitors

Pricing

Has featureFree Trial Available?Yes
Does not have featureFree or Freemium Version Available?No
Does not have featurePremium Consulting/Integration Services Available?No
Entry-level set up fee?Optional

SolarWinds Database Performance Analyzer Support Options

 Free VersionPaid Version
Phone
Email
Forum/Community
FAQ/Knowledgebase
Video Tutorials / Webinar

SolarWinds Database Performance Analyzer Technical Details

Deployment Types:On-premise, SaaS
Operating Systems: Windows, AWS Marketplace app
Mobile Application:No