Raise an Event Alert when a database is dropped
There is currently no alert when a database is dropped or detached from a server. SQL Monitor should create an Event alert to record when the drop happened. Obviously this might be intentional (e.g. the alert you have now that records a database is offline), but it might be accidental or unknown to the DB team (E.g. a vendor drops their database).
Because it will (hopefully) be an intentional action, and quite probably no plan to ever re-attach the database, the alert should be an event alert rather than a normal alert (the normal alert would never end)
A similar suggestion has been raised before, and there was concern that a custom metric raising events might spam users. I don't think this would be a problem if it was a built in alert. There is a comment in that suggestion that matches this one.
-
Greg commented
This came up again for me today when a vendor dropped a database while doing maintenance and we started having support calls come in from users around 10 minutes later. It'd be nice to know what database was dropped, when it was dropped, who it was dropped by, etc. Having an event alert as a warning of what might be coming would have been very helpful.
-
Greg commented
Came across this again today. Last week I set a few databases offline to make sure that nobody complained. This (correctly) triggered alerts that the database was unavailable. However, when I dropped the databases today, the only thing I saw was that the unavailable alert was ended. This still feels odd to me