TrustRadius
Solarwinds Database Performance Analyzer presents a database performance and development solution.SolarWindsOne of a kind2017-07-21T20:57:47.305ZI 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 ServerStephen SwanDatabase performance monitoring made easy2017-04-06T21:50:29.191ZSQL 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 ManagerMike MillerFun with Solarwinds Database Performance Analyzer for SQL Server2016-08-15T20:49:34.140ZWe 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 SpotlightSamir Patel, PMPSolarWinds DPA for DBAs!!! Working Smarter, Not Harder!2016-02-05T20:45:23.548ZWe 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,9Johnny GarciaGreat tool for long term query performance monitoring.2016-02-17T18:26:33.645ZUp 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 MonitorNathan Heaivilin
Unspecified
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>
Show Filters
Filter 32 vetted Solarwinds Database Performance Analyzer for SQL Server reviews and ratings
Clear all filters
