TrustRadius
Solarwinds Database Performance Analyzer presents a database performance and development solution.https://dudodiprj2sv7.cloudfront.net/product-logos/Gg/Bs/POP0NKN189DG.JPEGSolarWindsWhy DPA can save your firm money, help developers, and ease DBA job.2019-02-15T18:14:32.122ZWe run six separate DPA servers covering three different database software vendors. Coverage includes TEST Databases where developers can instantly observe metrics from their most recent changes. Production coverage, of course, is crucial to rapidly identify SQL and VM performance matters and observe changes based on the volume of transactions. This tool is the first place hundreds of developers, admins, and managers use to check app performance.,Top N SQL queries.
Outstanding UI for rapid examination and drill down to detail data.
Intuitive UI design - better than any other product in its category.
Enabled us to immediately shift DB related performance matters first to developers so that our DBA's can focus on more important matters.,Allow alerts to SMS (text message).,10,Total requests to DBA team dropped several hundred percent after the rollout of the tool. Since the tool works so well, developers/managers/admins are requested to FIRST analyze by themselves, and only after their inability to identify or resolve the problem, promote to the DBA team.
Ease of implementation and upgrades combined with self serve monitoring, automated reporting, and alerts have all reduced valuable DBA team effort and time, allowing them to focus on more important tasks.,Insights provided by the tool rapidly and continually allow developers to code and modify increasing transaction throughput and reducing transaction time. Personally, I've identified and validated transactions in question. Also, I use this tool to compare new releases of application software against past performance. The top N SQL list is an excellent metric to first investigate after any application upgrade.,Any Tuning advise is worth investigation. Past experience implementing suggestions from Tuning Advisors has significantly increased transnational throughput.,Datadog and DynatraceCraig SolinskiGreat for general monitoring2019-01-29T19:39:55.008ZSolarwinds 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.,8,The tuning suggestions reduced wait statistics by 80% when a new procedure was introduced without proper indexing.
Code has been reverted thanks to the data provided by SolarWinds Database Performance Analyzer.,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.,The index suggestions have been helpful. When new procedures have been introduced, the Table Tuning Advisors has made significant improvements.,Emmanuel BradleyMore than Satisfied2019-01-22T19:58:48.878ZThe ability to monitor, in real time, some new database servers we purchased is key to making them as effective as possible. We also needed visibility into inefficiencies surrounding our existing servers. Having a system with email alerts, AD integration, at-a-glance holistic dashboard views, and resource monitoring were key, but DPA goes over and above with index and query recommendations, and integration with our existing Orion platform. Already having Orion meant the Database Performance Analyzer was sort of a no-brainer, but the features of DPA have proven that it's worth the money.,Customizable Alerts
At-A-Glance Categorized Statuses and Wait Time Trending
Holistic Server/Application Monitoring using Orion,Availability Group status monitoring could be a little more developed, and sometimes it doesn't report the correct primary replica until the page is refreshed.
DPA reports on queries that may benefit from tuning, but it would be great if you could turn off the recommendations for specific databases, such as vendor application databases where procedures are not likely to be touched.,10,DPA is licensed per instance analyzed so, for us, only the higher priority database servers are monitored.
DPA is not dependent on Orion, but integrates with it. This means if you don't need all of the cool features of Orion and want to just pay to monitor the database instances then you can install it all by itself.,We're constantly on the lookout for indexes that can be created or made better using DPA. It is so easy when a hyperlink is provided that shows you the exact statement to run (minus the name) that will create the recommended index. DPA shows the information on existing indexes, columns, size, type, unique, and even the fragmentation percentage.,There is so much within Orion that it's hard to know where to begin. You can quickly go from a high-level network map to an individual database and single query within Orion when it's integrated with DPA. Easy to view bar charts within DPA are similarly displayed within Orion for wait times, along with how each query affects different resources on the system.JJ KroeschelSolarWinds FTW!2019-02-05T23:54:54.953ZWe are currently using DPA to check the reliability and speed of our databases and use the reporting to streamline our queries. We have had issues in the past due to slow response times from SQL servers and didn't know what was causing the issues. Using DPA allowed us to determine if it was hardware limitations or an issue in the query that was making the responses slow down.,Reporting, the detailed information regarding the issues it is showing.
Easy to Use Interface.,A better explanation of how to use the SQL plan should be implemented.
Implement recommendations from the console.,9,Not enough time to determine ROI,We have a financial database that is constantly referenced to create accounts for new hires or any moves they make within the district. The queries that run are very complex and run every few hours to make any updates to our AD groups. This has allowed us to streamline those to be more efficient,How could you not? Our Anti-virus database had this exact issue. It was causing abnormally slow response times for client tasks to be performed.,At this point, it has not been integrated into our Orion platform.,SolarWinds Network Device MonitorJose ParraSolarWinds, Hit after Hit. Keep the great products coming.2019-02-02T02:04:08.658ZWe use the performance analyzer to check the reliability and speed of our databases. We have had issues in the past due to slow response times from SQL servers and were unaware of the source. Using DPA, we were able to determine if it was hardware or an issue in the query that was making the responses slow down.,Interface is user friendly
Extremely detailed reports,Explaining in depth on how to use the SQL and how the plan should be implemented
Implement recommendations from the console,8,ROI unknown at this time,We run a database in our district that is constantly referenced to create accounts for new hires or any internal moves during employment. The queries that run are extremely complex and run frequently, updating our AD groups as needed. This has allowed us to stream those functions and clear up some of the overhead.,Our Anti-virus database had this issue. It was causing abnormally slow response times for client tasks to be performed.,John Gonzalez
Windows, AWS Marketplace app
SolarWinds Database Performance Analyzer
72 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
