TrustRadius
Solarwinds Database Performance Analyzer presents a database performance and development solution.One of a kindI 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.,10,We found significant performance gains even when just running the trial version. We were able to verify that remaining issues were no longer caused by the coding.,Idera SQL Diagnostic Manager,SolarWinds Server & Application Monitor, SolarWinds Netflow Traffic Analyzer, Microsoft SQL ServerDatabase performance monitoring made easySQL 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.,10,We had a situation in the past where Database Performance Analyzer helped us settle a dispute with a vendor. We had a system slowdown after an update and the vendor insisted the problem was the database. We were able to use the metrics provided by DPA to show that the database was performing optimally and the slowdown was in fact with the application. In another instance, we experienced a processing delay and we were able to use Database Performance Analyzer to immediately pinpoint the offending query and identify unexpected consequences in how the query was structured.,,SolarWinds Server & Application Monitor, SolarWinds Log & Event Manager, SolarWinds Network Configuration ManagerFun with Solarwinds Database Performance Analyzer for SQL ServerWe 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,8,Lowering monitoring cost Making our high cost DBAs more efficient Ability to get a comprehensive feel for our database environment,,Dell SpotlightSolarWinds 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,9Great 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.,7,Great tool for development in the performance servers. Generally, but not always, relevant to immediate emergencies in production, but always beneficial for long term query tuning.,,SQL Sentry, SolarWinds Server & Application Monitor
Unspecified
Solarwinds Database Performance Analyzer for SQL Server
32 Ratings
Score 8.5 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 for SQL Server Reviews

Solarwinds Database Performance Analyzer for SQL Server
32 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.5 out of 101
Show Filters 
Hide Filters 
Filter 32 vetted Solarwinds Database Performance Analyzer for SQL Server reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Reviews (1-6 of 6)
  Vendors can't alter or remove reviews. Here's why.
Stephen Swan profile photo
July 21, 2017

Solarwinds Database Performance Analyzer for SQL Server Review: "One of a kind"

Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
Solarwinds DPA is well suited to a DBA looking to improve performance over time. It allows tracking and alerting of queries. It makes finding pain points easy. This tool would not be good for a beginner DBA as it requires looking at execution plans and deciding where the problem has occurred.
Read Stephen Swan's full review
Mike Miller profile photo
April 06, 2017

Solarwinds Database Performance Analyzer for SQL Server Review: "Database performance monitoring made easy"

Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
This gives very detailed insight into your database performance. You do, however, need to augment this product and monitor your surrounding environment to get a complete picture of what is happening.
Read Mike Miller's full review
Samir Patel, PMP profile photo
August 15, 2016

Review: "Fun with Solarwinds Database Performance Analyzer for SQL Server"

Score 8 out of 10
Vetted Review
Verified User
Review Source
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

Solarwinds Database Performance Analyzer for SQL Server is well suited for environments that are mixed in nature. Environments where servers are on premises, virtual and cloud work well with this monitoring software.

Solarwinds Database Performance Analyzer for SQL Server is less appropriate for environments with few DBAs as the information that is provided needs DBAs for corrective actions to be taken.

Read Samir Patel, PMP's full review
Johnny Garcia profile photo
February 05, 2016

Solarwinds Database Performance Analyzer for SQL Server Review: "SolarWinds DPA for DBAs!!! Working Smarter, Not Harder!"

Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
DPA is great in identifying performance issues in real time and over time.
However, trying to troubleshoot specific issues with a certain execution due to bad data, is not possible. It captures execution plans but not the actual values being passed in so trying to identify the bad data is still a manual and time consuming process. If the tool could capture the passed-in values to a query execution that failed, that would make it tremendously helpful.
Read Johnny Garcia's full review
Nathan Heaivilin profile photo
February 17, 2016

Solarwinds Database Performance Analyzer for SQL Server Review: "Great tool for long term query performance monitoring."

Score 7 out of 10
Vetted Review
Verified User
Review Source
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.
SolarWinds Database Performance Analyzer for SQL Server is perfect for finding what the database queries are waiting on and where the waits are within the database system. Operational monitoring is more of a bolt-on with little consideration or forethought.
Read Nathan Heaivilin's full review
No photo available
April 12, 2016

Solarwinds Database Performance Analyzer for SQL Server Review: "Solarwinds DPA - Tools to help your DBA"

Score 10 out of 10
Vetted Review
Verified User
Review Source
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
SolarWinds Database Performance Analyzer (DPA) is well suited for any system that has a critical dependency on SQL Server performance. With DPA you can easily identify trouble spots including resource utilization down to individual database queries. If a customer complains about performance you can easily identify specifics and help provide information to resolve the issue.
Read this authenticated review

Solarwinds Database Performance Analyzer for SQL Server Scorecard Summary

Feature Scorecard Summary

Performance dashboard (6)
9.9
Intelligent alerting (6)
8.0
Top SQL (6)
9.3
Historical trend data (6)
9.2
Virtualization support (3)
8.8

About Solarwinds Database Performance Analyzer for SQL Server

Solarwinds Database Performance Analyzer presents a database performance and development solution.

Solarwinds Database Performance Analyzer for SQL Server Technical Details

Operating Systems: Unspecified
Mobile Application:No