Foglight vs. IDERA SQL Diagnostic Manager for SQL Server

Strengths [Foglight]

• Monitoring, Alerting and Management of on-prem virtualization and physical servers
• Historical trending and baselining are excellent and being able to compare a problem period against the same sets of data for a period when there was no issue is especially helpful as part of troubleshooting.
• Ease of use for end users is appreciated

Weaknesses [of Foglight]

• Creation and management of custom monitors is a developer level activity requiring Groovy skillset
• Less useful for management of an environment where there is a large amount of custom implementations
• Commitment to longevity of cartridges/packs for specific subsystems
• Ability to create custom schedules/alerts/escalations is only available via a 3rd party product (from a former Quest developer) and is not particularly easy to manage/manipulate
• Lack of API accessibility for external integrations to other analytics (splunk, etc.)

Incentivized

If you have several SQL servers and don't have a lot of time or resources to constantly monitor them, SQLdm will be very helpful. For one or two servers, it might be overkill. All of our servers are virtual, so having a tool that can monitor host metrics as well as guest metrics is a plus as well.

Incentivized

• Database monitoring
• Database management suite
• Customization (both monitors and dashboards)

Incentivized

• Database query optimization.
• Monitoring of databases in real time.
• Performance analysis and trends in the database.

Incentivized

• There are not many problems with this product
• Limited ability to use Foglight itself to solve problems it identifies

Incentivized

• Windows client has some issues. When you have small time intervals for your data collection, it can cause the client to become unresponsive and require you to restart it.
• It takes more time to get the web client running than it does to get the windows client running.
• The visualizations have been the same for the last eight years--could use a little bit of a refresh.

Incentivized

Incentivized

IDERA SQL Diagnostic Manager for SQL Server is an excellent tool, however I think Solarwinds Database Perfromance Analyzer is a slightly stronger more well rounded product

Incentivized

• Foglight has a positive impact on my company by being a complete monitoring platform that specializes in risk assessment, user diagnosis and management, and server monitoring ensuring a secure business infrastructure through predictive analytics, query analysis, anomaly detection, behavior tracking, troubleshooting, automated discovery, and more.

Incentivized

• It saves me a significant amount of time each week, freeing me up for other important tasks. I couldn't possibly monitor each server individually to the extent that SQLdm does.
• With the wealth of information I can get to easily, I can be more proactive in taking care of my environments rather than reactive. The times when other people notice something happening before I do are few and far between.

Incentivized