23 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.6 out of 100
14 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.1 out of 100

Feature Set Ratings

    SQL Performance Monitoring

    Foglight

    Feature Set Not Supported
    N/A
    9.5

    IDERA SQL Diagnostic Manager for SQL Server

    95%
    IDERA SQL Diagnostic Manager for SQL Server ranks higher in 5/5 features

    Performance dashboard

    N/A
    0 Ratings
    9.0
    90%
    3 Ratings

    Intelligent alerting

    N/A
    0 Ratings
    9.6
    96%
    3 Ratings

    Top SQL

    N/A
    0 Ratings
    9.6
    96%
    3 Ratings

    Historical trend data

    N/A
    0 Ratings
    9.6
    96%
    3 Ratings

    Virtualization support

    N/A
    0 Ratings
    9.6
    96%
    3 Ratings

    Attribute Ratings

    • IDERA SQL Diagnostic Manager for SQL Server is rated higher in 1 area: Likelihood to Recommend

    Likelihood to Recommend

    9.1

    Foglight

    91%
    6 Ratings
    9.6

    IDERA SQL Diagnostic Manager for SQL Server

    96%
    3 Ratings

    Likelihood to Recommend

    Foglight

    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.)
    Anonymous | TrustRadius Reviewer

    IDERA SQL Diagnostic Manager for SQL Server

    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.
    Greg Goss | TrustRadius Reviewer

    Pros

    Foglight

    • Foglight NMS is very light on resources given the amount of monitoring connectivity options it provides. It is one of the few that I've trialed in the past that offers SNMP v3 connections.
    • The dashboard is concise with the main areas of interest. It can be customized as well if you have a particular use case.
    • Setting up alerts is straightforward with the ability to set custom thresholds. Alert emails get sent by configuring a primary mail server with the option to add a backup mail server in the event of a primary mail server outage or connectivity issues.
    Roger Mialkowski | TrustRadius Reviewer

    IDERA SQL Diagnostic Manager for SQL Server

    • Database query optimization.
    • Monitoring of databases in real time.
    • Performance analysis and trends in the database.
    José Javier Dominguez Reina | TrustRadius Reviewer

    Cons

    Foglight

    • GUI interface is difficult to navigate
    • No APM capabilities. They left this space about a year ago
    • We have had issues with the GUI response times. On a regular basis, the interface can take several minutes to refresh
    Aletha Diaz | TrustRadius Reviewer

    IDERA SQL Diagnostic Manager for SQL Server

    • 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.
    Steven Gockley, MBA, MCSA | TrustRadius Reviewer

    Pricing Details

    Foglight

    General

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services
    Entry-level set up fee?
    No

    Starting Price

    Foglight Editions & Modules

    Additional Pricing Details

    IDERA SQL Diagnostic Manager for SQL Server

    General

    Free Trial
    Yes
    Free/Freemium Version
    Premium Consulting/Integration Services
    Entry-level set up fee?
    No

    Starting Price

    $1,996 per instance with first year maintenance included

    IDERA SQL Diagnostic Manager for SQL Server Editions & Modules

    Edition
    Standard via eCommerce1,996.001
    1. per instance with first year maintenance included
    Additional Pricing Details

    Alternatives Considered

    Foglight

    I have experienced great business insights from the operation of this product on our data and work environment. It closely monitors workflows to ensure that there is positive and regulated outcomes that meets company standards. It detects problems in early stages to avoid critical cases that can lead to higher cost and time wastage. It prepares data and all workloads to make the process of migration from our company to cloud servers more simple.
    Emma Woodbury | TrustRadius Reviewer

    IDERA SQL Diagnostic Manager for SQL Server

    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.
    José Javier Dominguez Reina | TrustRadius Reviewer

    Return on Investment

    Foglight

    • Positive - near instant alerts help combat potential problems quickly
    • Positive - minimizes business interruption
    • Positive - limits disruptions to productivity
    Jaime L. Regan | TrustRadius Reviewer

    IDERA SQL Diagnostic Manager for SQL Server

    • 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.
    Greg Goss | TrustRadius Reviewer

    Screenshots

    Foglight

    IDERA SQL Diagnostic Manager for SQL Server

    Add comparison