• Report specific Database usage by user

    Is there a report or other mode to discover whether a database (on a multi database server) has been accessed by a user or not in a specified period of time (like 3 months)?  We have enterprise servers that contain 40-50 databases and sometimes the business…

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

  • Credentials change for oracle db hangs

    Credentials change for Oracle db hangs (until session timeout) on "applying modified settings" when save changes is executed.  (Agent 5.7.5.30)

    There is no error or other message/feedback at all.  The credentials are verified on the target.

    Is…