Return
-
Title
Can DBSS - Unavailable rule be configured to ignore Offline databases? -
Description
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. -
Cause
DBSS - Unavailable doesn't have an option to ignore specific states. -
Resolution
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. -
Defect ID
FOG-4715