Database name "like" filter for "Database Unavailable" alert
In our environment we have several systems (3rd party ETL/reporting packages) that create and drop databases as part of their normal operation.
Would be good if the "Database Unavailable" alert allowed configuring to ignore drops of database names either matching a "LIKE" filter or perhaps more advanced a regex filter.
Peter
shared this idea
-
Patrick Keisler
commented
We are currently using a distributed AG to migrate and upgrade databases to a newer version. The global secondary AG will always have the databases in a mode that is NOT online. While we don't need to monitor the databases in an "upgrading" state, we do have other databases on that global secondary that are online and are not part of the AG that do need to be monitored. Having a filter would be greatly appreciated.
-
Abhijit
commented
Filter option required so that you could ignore databases that are in an offline state.
it possible as someone purposely kept db's in offline state which can be avoided using filter -
Kevin Lewis
commented
An additional spin and addition on the above.. to be able to filter state so that you could ignore databases that are in an offline state. Why? If a database is an offline state its because someone on purposely did it, as opposed to say a state of emergency or suspect.