• How do you deal with delegating foglight access in your organization?

    We have recently migrated from Quest's Spotlight (for databases) to Foglight (for databases).

    In doing so we have run into a few challenges: The most important of which for us is delegating (non administrative) access.

    Spotlight had a fairly mature…

  • Corrective actions triggered from Foglight to address space alarms

    Similar to what's been discussed in this post earlier -  How to configure corrective action against alarm
    I am trying to implement a corrective action triggered via Foglight to auto-remediate SQL server space alarms e.g. increase max size of file and…

  • Has anyone used Foglight to capture CDC events and report on them?

    I'm looking to see if change data capture events can be logged by Foglight and ultimate be reported out to various groups, mainly for auditing purposes.  I'd like to do this for multiple instances that are already being monitored by Foglight.

  • LED headlights and Fog Light Install for 2018 touring

    Hey guys,

    I'm planning to upgrade the stock halogens headlights to LEDs because for the looks. Is there a recommended LED blub for the high beams or any will work just fine? I'm also planning on adding fog lights to my Mazda this February and since its…

  • Discrepancy on the hardware requirements for Foglight Management Server

    Maybe I'm missing something, but I'm trying to calculate our hardware requirements for the FMS.

    I've got to think the second example in the walk-through may not be for the Foglight Management Server alone.

    From https://support.quest.com/technical…

  • Has anyone configured Foglight for SQL Server to handle multiple vlans (FTI Compliant, PCI Compliant, No Compliance, etc.)?

    We've investigated a few different ways to handle this but I wanted to see if anyone had already addressed this in their environment. When we spoke to Quest they didn't really have any use cases regarding compliance requirements. I've started reading…

  • looking for a query or report that can give me the aggregate of a group of servers i/o waits

    Hi,

    We have added a new blade to one of our SQL Server Clusters, and it is on a larger FI switch.  I am looking for a way to aggregate  the total i/o waits on a group of servers that are running on that blade.  Does anyone have a query or a way to do this…

  • Scope rule to error text

    We have a scanning tool that hits every SQL server with bad logins on a regular basis. this generates Sev 20 errors in the log, which si good. however, I don't really want to deal with a few hundred of these a week from a know source. Is there a way to…

  • DBSS - Long Running Job exception duration for single job

    Hello All,

    This alarm "DBSS - Long Running Job"  have a global fire threshold for all the jobs.

    I can see that there is an exception in order to exclude specific jobs.

    Does there is a way to make an exception for a single job duration that will…

  • Foglight Database Expansion Pack

    Note: Database Expansion Pack download was updated in 2022

    Hello all.  I am pleased to provide the latest release of my Foglight Database Expansion Pack for general use.  Any customer (current or future) is encouraged to install this pack into their Foglight…