SolarWinds Database Performance Analyzer vs. SolarWinds Server & Application Monitor

This is an easy 10 because I actually have recommended this product to multiple clients and colleagues! Any shop that writes its own SQL queries will benefit from the insight provided by SolarWinds Database Performance Analyzer, so they know which of their queries is causing a bottleneck. Small shops or databases with only a few tables likely will see far fewer opportunities for optimization.

Incentivized

It is a well-suited software for monitoring and surveillance of your deployed nodes. The error-readability and filter options for filtering out logs and errors could be improved. But overall, it has a good UI design, is user-friendly, and is very easy to learn and access for new users.

Incentivized

• Maintains historical SQL execution data, enabling forensic analysis
• Has the ability to slice and dice the data so that you can drill down to the execution of a single SQL statement being executed by a stored procedure
• Alerts to when the consumption pattern changes
• Shows historical average run times against the current, illustrating problems when they arise
• Provides tuning advice based on best practices

Incentivized

• Monitor Azure Cloud Severs- We use SolarWinds SAM to monitor Active Directory and DNS on Several DCs published on Azure Cloud.
• Monitor Hyper V and VMware - SolarWinds SAM monitors applications on both Hyper V and VMware, while also monitoring the physical host machines.
• It also helps us monitor Warranty expiration for physical servers.

Incentivized

• Alerts seem to be lacking in DPA compared to competitor's tools. They can be setup but are not quite as easy or as helpful as some other tools I have used.
• Grooming/pruning the repository database isn't very easy. We don't manage a lot of instances but our repo DB has grown pretty significantly.
• At times when I am drilled-down to a chart, it can be difficult to navigate around from that point to another time range/query/metric.

Incentivized

• Custom application monitors can be a little tricky to configure.
• Logic in custom alerts can be a little hard to follow and figure out.
• Inability to monitor certificates on custom applications or SQL Server.
• Can be a little slow at times with on-prem SQL server.

Incentivized

We have relied on this product for a very long time and it continues to exceed expectations. The product is a vital part of our organization at this point, it would not be very ideal for us to abandon it. We use it almost every day and depend on its alerts for critical parts of our business

Incentivized

We are heavily invested in Solarwinds products for a reason. They are generally easy to setup and run with, requiring only some interfacing with support or help articles on rare occasions. They do what we bought them to do and we can't ask for more.

Incentivized

I don't want to think about managing clusters of SQL servers in the future without this tool. We have demoed other tools and SolarWinds Database Performance Analyzer is the gold standard for usability and insight into what your servers are doing. The UI is a bit dated, but everything is laid out in a logical manner and drilling down into queries or timeslices is extremely intuitive.

Incentivized

SolarWinds Server & Application Monitor is quite easy to use and super versatile. It allows you to do just about anything you can through premade templates or through scripting. You can use an agent on the servers if you want to, or you can monitor through WMI or SNMP credentials. You can customize thresholds for alerting quickly, and you can configure alerts to be as complex or as simple as you want.

Incentivized

The tool works and monitors items 24x7, it only requires maintenance a little more frequently due to security fixes in the Windows operating system.

Incentivized

The graphical interface and the performance of the database leave a little to be desired, they could be better explored.Some functionality and screens do not work well depending on the browser used. The integrations never had any problems or caused crashes in other systems.

Incentivized

I have had to use their support on a few occasions, for reasons that I am not clear about until recently I have always had problems upgrading the software (although the last 2 updates have gone without issue which I am very pleased to say). On those unfortunate occasions, the support has been brilliant with either excellently documented guides on how to resolve the issue by myself or have been hands-on with calls and screen sharing to remotely fix the issue. Every time the problem was sorted and more importantly, nothing was lost (apart from a bit of time). And as I stated above whatever the problem was that was causing my upgrade issues appears to have been resolved in the last 2 updates.

Incentivized

I think there was only a couple times I had to open a support case for SAM and one time they got multiple engineers on the phone to get a better idea what I was trying to monitor and was able to point me in the best direction to monitor that system.

Incentivized

It was sufficient to read their documentation and watch videos.

Incentivized

Follow the guidelines for the capacity of the servers. We found that the DPA databases were getting rather large and also that there are ways to reduce their size built into some of the options.

Incentivized

Make sure SNMP and WMI are configured ahead of time

Incentivized

At the time, we found SolarWinds Database Performance Analyzer to be easier to setup and to have a richer feature set than Redgate SQL Monitor, plus, from what I remember, the DPA pricing worked better for us over the course of a year. We're very happy with all the features DPA has to offer.

Incentivized

Nagios requires far more manual work to configure than SolarWinds does, though that also encourages customization and perfect-fit solutions. Nagios also requires far, far fewer resources to run than SolarWinds: SolarWinds wants great gobs of memory and disk, while Nagios is refreshingly humble. Nagios starts working from the first minute, too, whereas SolarWinds needs lots of set-up time.

Incentivized

It is hard to find the recommended SQL setup and convince others that is the way you should configure the server when you set it up

Incentivized

• It has allowed us to progress as an organization with much less reliance on a direct DBA than would traditionally be required
• Allowed us to be much more proactive in our performance monitoring and responding to issues that would affect users.

Incentivized

• Ability to sunset multiple legacy monitoring platforms.
• A single pane of glass across global locations (Enterprise Operations Console) simplifies monitoring for junior staff.
• A single toolset allows staff from across the global environment to share knowledge and quickly set up/modify monitoring.

Incentivized