while Azure Sql Database remove from Elastic Pool , is there any alert /notification /policy that notify that database removed from that Elastic Pool

Question

Hi

We have around 100 Db servers and each DB server has at least 20 DBs and one or 2 elastic pools .

Due to some automation / other maintenance activities , we have removed DBs from the elastic pool.
So need some alert (alter query ) that notify that certain DB is moving out elastic Pool .

we have developed an automation that applied the tag on each DB as "Elasticpool" : "ElasticScale100dtu"
if Db out from elastic pool then its Tag Update to "Elasticpool" : "NA"

Please help to track events then the DB is moving out from Elastic Pool and when DB is attached with Elastic Pool.
so that we apply tag on it

Answer 1

Thanks for your patience @Paritosh Mishra .

We can create alerts on Azure SQL Elastic Pool that will send a notification anytime there is a write operation on elastic pool. As an example if we add a new DB or remove a DB it will send a notification to alert us. Please check the below alert that we can create:

We an create sms notification, mail notification etc. for receive these alerts.

Please let us know if this helps or else we can discuss it further.