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

Paritosh Mishra 41 Reputation points
2022-06-14T06:40:33.643+00:00

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

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Anurag Sharma 17,261 Reputation points
    2022-06-17T06:26:24.1+00:00

    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:

    212320-image.png

    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.