• 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…

  • User Defined Collection Not Showing Up

    Attempting to add a UDC on different SQL servers spanning different versions and the query itself will verify correctly, I have set the key and all the types but it still will not appear in the UDC Overview screen.

    The closest error I can find is:

    2021…

  • How to customize a Rule/Alert for missing backup for only system databases

    How do I customize a rule/alert to only alert on user or system databases? Our system databases are only backed up once a week, whereas user databases are daily. I need to adjust the rules/alerts accordingly. 

  • SQL Server session blocking alert - where do I find this?

    I have recently implemented Foglight for MSSQL after using Idera DM for 10 years.  I cannot find a session blocking alert but do see the metric on the Overview screen in the Instance Performance section. 

  • 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…

  • SQL Grant permission script error

    Dear All, 

     

     We have recently upgraded the  Database cartridge to 5.7.5.35.  We are trying to configure a SQL 2012 DB, when we try to manually execute the Grant permission script  we are receiving the below error.

    msg 207, Level 16, state 1 line 27

    Invalid…