Foglight vs. SolarWinds Database Performance Analyzer

It really depends on why my colleague is evaluating Foglight. If it is for Database monitoring and management, I highly recommend it. If it is for anything else, I would encourage them to look at others in this space.

Incentivized

I believe that SolarWinds Database Performance Analyzer is a great choice for an organization that does not have a specific DBA or one that is still growing into the role. SolarWinds Database Performance Analyzer is filled with hints, tips, and explanations of the various readings and metrics. This is very useful to help understand what is happening and why, what it means, and what some potential solutions are towards remediating any issues. This is extremely valuable for our development team, allowing them to be more proactive with the queries they write in viewing how they perform and where bottlenecks might be.

Incentivized

• VMWare Monitoring
• Custom use of scripts and dashboard
• Performance Analysis for Database
• Remote Monitoring for Linux and Windows.

Incentivized

• Ability to drill down to wait for the issue and have a clear path as to what may be causing the issue.
• Ability to quickly add a new target and the ease of installation and upgrades.
• Reporting features to group my most troublesome customers into a daily report in one email.
• Excellent customer support on any issues I can't immediately solve.

Incentivized

• Foglight allows detecting and diagnosing performance problems simplifying hybrid environments, it is a solution that has perfect features which work in a flexible and intuitive way, it allows database performance in a safe and fast way. It works perfectly with nothing else to add.

Incentivized

• Resiliency of the Monitoring checks after the server underwent maintenance reboot. My experience is the monitor (Action) needs to be started manually. If possible it can automatically detect service/server then start to monitor again when system is back up.
• Much lighter UI.
• Granularity up to minutes.

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

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

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

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

Foglight was chosen years ago as a replacement for Groundwork. After 2.5 years of implementing Groundwork things were still not complete and the decision to go with a more formalized solution was made. Foglight installed easily and quickly nearly across the board and the full implementation for complex infrastructure was completed (with no Professional Services) by us in under 4 months. Nagios is a wonderful toolkit but you have to be ready to build what you need. It's flexibility and breadth are excellent features but with that comes the need to define things very tightly lest you embark on the project that never ends (see above about Groundwork). Dynatrace is an excellent APM tool and has advanced analytics but as a general infrastructure monitoring tool it is actually very expensive and to be honest does not have the same focus and full feature set that it does on it's APM (which to be fair is it's wheelhouse). vROPs (we also have) is a wonderful tool but focused (and rightly so) on satisfying the VMware engineers in the crowd and doesn't put itself out there too far to make things palatable for the non-engineering crowd.

Incentivized

I have used Spotlight (for Oracle on RAC) but it has been several years. The dashboard was crisp, clean, and intuitive, but the tool had a significant overhead. However, no competitor made a tool that met our needs at the time. I have also used Idera's SQL Diagnostic Manager in more than one company. That tool is helpful for a larger environment than we currently have. But I think it is better at alerting than DPA but worse at just about everything else. The good thing is you can flag an alert as acknowledged, so you stop getting emails. The bad thing is I don't think I could use it to troubleshoot issues like I do with DPA. I do not have enough experience to provide helpful feedback on the others selected.

Incentivized

• Positive - near instant alerts help combat potential problems quickly
• Positive - minimizes business interruption
• Positive - limits disruptions to productivity

Incentivized

• Paid for itself in days. We had a stored procedure that could not meet its SLA, DPA highlighted the issue and contributed to the resolution.
• We had a stored procedure that we were able to calculate as running in 9 milliseconds, unfortunately, we had transactions coming in 7 milliseconds, resulting in duplicate transactions, indicating that a mutex function was needed.

Incentivized