Regresar
-
Título
Can DBSS - Unavailable rule be configured to ignore Offline databases? -
Descripción
Is there a setting to ignore databases in offline status? Some times taking a database offline is necessary but the alarm for DBSS - Unavailable fires every time. -
Causa
DBSS - Unavailable doesn't have an option to ignore specific states. -
Resolución
WORKAROUND 1
The database can be excluded manually regardless of state as described in KB 4295742.WORKAROUND 2
Create a customized rule which uses status from DBSS_DATABASE_PROPERTIES as an alternative.
STATUS
Enhancement request number FOG-4715 to exclude OFFLINE databases has been submitted to Development for consideration in a future release of Foglight for SQL Server. This has also been extended to consider excluding databases in the RESTORING and RECOVERY state. -
ID de defecto
FOG-4715