SolarWinds Database Performance Analyzer Reviews

Solarwinds 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.

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.

As a consultant, I recommend and use SolarWinds across multiple clients currently at Nortek/Broan-Nutone, BlastMotion, and Hansen and Adkins. I use this on a daily basis to assist me with monitoring SQL servers and assisting me with troubleshooting performance issues as they arise. I have also used SolarWinds DPA to set up alerts for issues like low drive space and query plan changes.

We had an issue recently where we experienced poor performance of a query due to a plan change. DPA pointed this out and I adjusted how often I updated my statistics, which helped this query. I would have a hard time knowing that the query plan change was the root cause of the issue had DPA not told me.
One thing that might be helpful though would be if DPA saw this plan change and then told me I should update my statistics, since I had to figure this out and do this separately on my own.

The database team uses DPA to manage up to 50 licenses. Only 5 team members who are DBAs actively use the tool. All SQL performance problems from large PeopleSoft DBS to Cots applications (500+) are covered. Performance problems can come from all directions so this tool is extremely useful because it's a catch-all.

A database should be more optimized to run faster and efficiently. SolarWinds Database Performance Analyzer is one of the best applications which is used as a management and performance monitoring solution for any database. This software is straightforward to use and configure. And it is user-friendly. In our organization, we are using SolarWinds Database Performance Analyzer to manage database performance issues such as errors, long-running queries and more.

We had some issues related to databases such as slow queries and data losses. Using SolarWinds Database Performance Analyzer, we were able to identify problems related to our databases, and now they are running without problems.

Database Performance Analyzer is really helpful in our organization to find DB issues. It does in-depth database performance monitoring and provides a lot of valuable data to us.

We had an issue where databases were going to a hinge state, and using Database Performance Analyzer we were able to find the jobs that were responsible for that.

Our business lines span many industries and have a vast array of projects in production. Many of the environments we have must be segregated, and SolarWinds Database Performance Analyzer offers us a clear, detailed view of these environments through a single pane. Our DBAs can more quickly address issues and quickly settle the "hardware versus software" debate between engineers and developers.

One instance where SolarWinds Database Performance Analyzer saves us is cost savings. We are able to see what inefficient stored procedures do to the resources we pay monthly for. We saw the need to pull a couple of developers off a project and have them concentrate on optimization and indexes, and we were able to reduce resource consumption enough to hire more developers.

It allows us to keep a close eye on our database. In the event we run into slowdowns, we can easily identify the issue using SolarWinds Database Performance Analyzer before larger issues pop up. Since we've implemented it, we are able to proactively keep our system running smoother with fewer service interruptions.

We recently released a new build of our in-house software. We were experiencing very high utilization on our database server which essentially stopped all critical usage in our database. Using SolarWinds Database Performance Analyzer, we were quickly able to figure out exactly what query was causing the issue and resolve the problem much faster then we would have been able to without SolarWinds.

In our company we use SolarWinds Database Performance Analyzer for proactive performance monitoring and anomaly detection in database overall health. This product gives us a first look at the big picture of the database performance. We configured some alerts and mail notifications, which saves us a lot of time. Our most common use case is to react to changed execution plans and take appropriate actions before end users of the systems start to complain about performance problem and response times.

I cannot share an example due to regulatory restriction.

We use it across our department to monitor our database landscape. We have different flavors of databases across our landscape, and SolarWinds for years has been an important part of the strategy for our monitoring solutions for the database tier across the landscape. It is very intuitive and quite easy to implement.

We had some customer promotions going on and the database was suffering from blocking sessions a lot during these promotions. DPA helped to pick these quickly and these were raised with the concerned teams to ensure that this can be handled well in time to ensure minimal impact to the business.

DPA is currently used by our development and support team to monitor our core database to keep an eye on performance day to day to avoid any rogue queries or new application causing issues for our business as a whole. In the early days of our business platform it was used to refine our queries to provide a better user experience.

We have a windows service that calls the DB for an action. If the action wasn't to be performed it was supposed to go to sleep and wait for a few minutes before trying again. However with a mistake in the code the procedure it called ended up being called every tick which lead to 1000s of executions per minute. DPA wait time status highlighted this within no time which lead immediately to the root cause, including snippets of the SQL text, allowing this to be resolved within minutes of becoming aware of it (and more importantly before any complaints that the system was running "slow")!

We use this product to diagnose and maintain the good performance of SQL Servers. We find degradation or lag, and it also helps issues with queries to be addressed.

When root cause performance hits through the resources tool, we then correlate that to the queries that were blocking or had waits. It is very useful to have specific times and details to find underlying issues. Then we can use the query help tool that offers suggestions to tune the queries that may help avoid this in the future.

We use DPA for database monitoring across the enter enterprise, dev/QA and production. We connect it to Oracle, SQL and MySQL Database Servers. We use DPA as a single source of monitoring for database performance issues. The historical and real-time query monitoring allows us to troubleshoot and quickly identify the root cause of a poorly performing server.

We have a web based application running on Oracle that began experiencing daily performance issues every morning. We were able to quickly review query historical Top SQL Statements from the impacted time periods and identify a problematic query. As a short term fix we disabled the job running the query. Using tuning advice also provided in DPA we were able to improve the query causing the issue for a permanent fix.

It is used in IT to monitor database performance and to assist with troubleshooting when there are performance issues with key applications. It is primarily used by our Database Administrators and has assisted in maintaining key performance metrics. It has allowed us to be proactive in our approach to performance monitoring and being able to resolve problems before they affect users.

In troubleshooting a key application, it was able to highlight a query that had a heavy impact and cost on the performance that significantly affected users' ability to utilize the application. It allowed us to rebuild the query and schedule it for a different time where it was less impactful on user performance. This resulted in significant improvement in user surveys regarding performance.

We use it at the data warehousing and analytics group to monitor the load and set up alerts on the data warehouse server. We have set up alerts on long-running queries, blocking other queries, deadlocks, instance availability, unused indexes, etc. Some of them are very useful, but the deadlocks alert can be improved to show what queries were in the deadlock, so we can improve our solution.

It helps us balance the load and find queries that need optimization.

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.

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.

Solarwinds is used by our department to identify performance issues with our system using a Sybase database.

DPA helped us demonstrate to our vendor that the majority of a wait time for a query was due to a badly formed SQL statement.

Our SQL server performance monitoring is done by using DPA SolarWinds. It's used in our department only.

In multiple performances issues logical reads , execution count and execution plan helps in tuning queries and comparing results after tuning. Before and after query performance details on same graph is very usey

The SolarWinds DPA module is used mainly to monitor our MSSQL instances for performance. We had lots of issues related to DB performance and we were not sure about the root cause before implementing DPA. Now, we are getting proactive alerts when there is a deviation from the performance baseline configured in the tool and we are very happy with it.

We had an issue where the application performance very slow. After troubleshooting and looking at DPA analytics we identified that SQL query was running slow and after tuning it the issue got resolved. This tool also helped us to create a performance base line and as soon as the query response time varies from the base line we get a proactive alert.

Currently, our DBOps and SysOps teams use SolarWinds Database Performance Analyzer. Both teams use it to analyze our database clusters and individual databases.

It's shown blocking that has occurred and allowed us to fix these issues.

SolarWinds Database Performance Analyzer is used by our database and applications team to ensure the application code is working as expected, as well as to monitor database performance.

When a developer modified code, it caused application performance to slow down to a crawl. SolarWinds Database Performance Analyzer helped isolate the issue.

Discovering data performance issues. Creating an index based on the suggestions by DPA. It can be accessed by all developers to review their query or performance-related issues.

Too many to say.......

We have been using the database analyzer to monitor any changes that have occurred or any issues currently prompting. It has helped when looking at the trends around the flow of information and possible connection issues. We use it on a regular basis within two of the main departments. It is a great product.

Our database crashed based on our customer records. We had a backup that we monitor on a regular basis. The tool helped when monitoring the newly uploaded database to see what caused the crash or if it was randomly occurring. It appeared it was a server issue and not the software.

It is being used to monitor all production instances for the whole organization.

Due to inefficiently written applications, DPA is instrumental in identifying blocked sessions. This allows the admins to evaluate and possibly kill the blocking session and keep end-users productive.

DPA is an essential part of performance monitoring our hybrid Demand Management Solution for hosted customers, and select on-premise customers. Automation is essential considering the number of customers, the schema comprising approaching 3,000 tables and over 5,000 code artifacts. Daily summaries of the last 3 days of Top SQL resource consumers give us ongoing snapshots by which to spot trends and anomalies that DPA's functionality enables us to investigate to query and table level.

There are far too many to isolate a single, detailed, case. Suffice it to say that hour-long queries, down to many-per-second queries have been identified by DPA as top consumers. The mix of code-pinpointing and index usage (or the lack thereof) has enabled multiple hours of elapsed and CPU time to be cut for very high volume customers (row-counts over 10 Billion in a 1.2TB Database), such that very narrow SLA windows are conformed-to.

Used to monitor production database performance and identify areas for tuning.