SolarWinds Database Performance Analyzer helps you become the best DBA you can be.
March 31, 2020

SolarWinds Database Performance Analyzer helps you become the best DBA you can be.

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SolarWinds Database Performance Analyzer

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
  • In today's world, people want access to information faster and faster. Our organization had some applications that were not operating as quickly as users thought they should. With SolarWinds Database Performance Analyzer, we were able to pinpoint the issue, create new indexes, and speed up access to the information.
  • SolarWinds Database Performance Analyzer allows our technology staff to focus on other areas of the business. When a database issue arises, SolarWinds Database Performance Analyzer provides alerts to the staff, rather than running database analysis tools on an adhoc basis.
  • For smaller environments like ours, SolarWinds Database Performance Analyzer is a cost effective solution.
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.
As mentioned previously, SolarWinds Database Performance Analyzer's main advantages lie in its database tuning and query adviser section. SolarWinds Database Performance Analyzer generates suggested queries and indexes in a script format so that all you need to do is copy and paste them into your database manager and execute them, with minor changes, such as names, etc.
SolarWinds Database Performance Analyzer makes it easier for those that don't have a lot of experience with SQL queries, and allows any business to improve the performance of their databases.
  • SolarWinds Network Performance Monitor
  • SolarWinds Server & Application Monitor
Together with Solarwinds Network Performance Monitor (NPM), Solarwinds Server and Application Monitor (SAM), and SolarWinds Database Performance Analyzer (DPA), makes troubleshooting issues simple and straightforward. By using AppStack and PerfStack, you can watch the interactions between the various application and network systems to correlate issues and narrow down the culprit, saving a tremendous amount of troubleshooting time.
This allows the systems to be fixed more quickly, enabling your users to continue their functions with minor inconveniences versus full-blown outages.
All of our database servers are virtualized. By combining SolarWinds Database Performance Analyzer with Solarwinds Virtualization Manager, we gain tremendous insight into the performance of our database systems. Using the reporting systems of both SolarWinds Database Performance Analyzer and Virtualization Manager, we can easily correct any configuration issues, and assign more resources when needed. This keeps our databases running as expected, and maintains consistency across our environment.
Our organization is currently not running on Microsoft Azure or AWS, so we have no need for SolarWinds Database Performance Analyzer to monitor cloud databases and analyze performance.
However, we do use SolarWinds Database Performance Analyzer to monitor on-site databases. If any performance issues arise such as slow queries, blocking, or deadlocking, our technology team gets alerts, which allows them to quickly identify and correct any issues.
Our organization has not compared SolarWinds Database Performance Analyzer with any other products. We selected SolarWinds Database Performance Analyzer for the simple fact that we use other SolarWinds products, and we wanted a solution that both compliments and integrates with our other monitoring solutions.
SolarWinds Database Performance Analyzer was the only product that met both of those requirements.
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.