Foglight vs. IDERA SQL Diagnostic Manager vs. Spotlight

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

SQL Server [Business Intelligence] Manager is useful for tracking performance across SSIS, SSRS and SSA and have the data represented in dashboards. It helps improve performance and helps end users. However, several features are redundant for smaller organization that can use the tools that comes with existing Microsoft products. These features also takes time to learn and use.

Incentivized

Spotlight’s ability to consolidate data from various entities and provide insightful reports is highly beneficial. It streamlines financial reporting, allowing professionals to focus on advisory services and strategic decision-making.Small businesses, nonprofits, and organizations that need regular board packs or executive summaries find Spotlight useful. Less Appropriate: Certain industries (e.g., specialized manufacturing, healthcare, or research) have unique reporting needs. Spotlight’s generic templates may not cover all industry-specific metrics or compliance requirements.

Incentivized

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

Incentivized

• SQLdm does a good job of providing information at a high level, but also allows me to drill down to specific queries and events if needed. I don't always need to sift through tons of details to get the information I need. It also gives a very wide range of information from SQL specific metrics, to OS metrics, to VM metrics, all the way up to host server metrics.
• I like how the alert and notification system can be customized. For example, if you know a certain server regularly has long-running queries, you can adjust the alert to not fire unless a query has been running for 30 minutes while the rest of the servers fire after 30 seconds. That is very helpful in not being bombarded at dinner with alerts from a server similar to, "I've been at 90% cpu for 26 milliseconds!!!!!!!...and now it's back down to 30%" Good information to know, but not something you need to literally lose sleep over.
• I like how you can configure different servers to be monitored differently. For example, you can have a group of servers called DEVELOPMENT that you can turn on heavier monitoring on so you can test how changes in applications might affect the SQL environment, but in the PRODUCTION group, you may only want to enable the heavier analysis and logging when performance issues are actively being reported.

Incentivized

• Great SQL server monitoring
• Rewind and playback of previous times

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

• My only complaint was the cost.

Incentivized

the platform offers a clean, easy to use interface. You can customize reports and dashboard. Integration is also pretty good, you can integrate to Xero, QBO and MYOB and excel spreadsheets. It also offers very broad supporting documents and webinars. There are only two downside of Spotlight; learning curve (it could be a bit difficult at the beginning to learn the system) and price point (For small businesses, Spotlight Reporting can be seen as relatively expensive compared to other reporting tools)

Incentivized

I've never had to contact support, as of yet I have had no issues or problems with the tool. This is after 5 years of use.

Incentivized

Incentivized

IDERA SQL Diagnostic Manager for SQL, Redgate SQL, and MonitorLogicMonitor are similar products to each other. We decided on IDERA SQL Diagnostic Manager for SQL because our experience with locating heavy queries has been very good and it provides real-time monitoring of all servers and databases. It also allows you to have a large volume of historical data which allows you to analyze trends in the databases.

Incentivized

I think Dell is better with its dashboard and ease of use, but SQL Sentry is better at customization. We used Spotlight at my previous company, and SQLSentry at my current company.

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

• Allows us to quickly set up ETL processes as soon as we installed SQL Server.
• There's a lot of free/paid resources available online, decreasing development time.
• A tool with plenty of experienced developers.

Incentivized

• Spotlight is reasonably inexpensive, and any one of the multiple things we use it for more than justifies the cost.

Incentivized