Foglight vs. SQL Server Management Studio (SSMS)

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

The tool is excellent for managing virtually all aspects of SQL Server - multiple servers, databases, hundreds of tables and procedures, dozens of SQL Agent jobs. We have not encountered any situations where it is not appropriate.

Incentivized

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

Incentivized

• Database queries
• Database management
• Table design

Incentivized

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

Incentivized

• Sorting of executed queries not available
• Quality of life improvements on folders and managment
• Some outdated tools that need revamping

Incentivized

It's very user friendly. If you know T-SQL then you can use this. Really even if you don't it's not that hard to figure out. You can create things visually as well.

Incentivized

Incentivized

SSMS is very efficient and aids to do multiple tabs easily

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

• SQL Server Management Studio is our go-to tool for almost everything we do with SQL Server. Highly efficient and flexible.
• Compared to other alternatives, I would say we save at least 25% of the overall time we need to spend working in SQL Server.

Incentivized