Resource Health Alerts generated when Azure SQL database resumes from a Paused state

[Nicholas McCollum (nimccoll)]

I have a customer I am working with that has over 22,000 Azure SQL databases in their production environment. They have enabled Resource Health alerts on these databases. The databases are configured with the Auto-Pause feature to save costs when they are idle. By design when someone attempts to connect to a Paused instance the database begins its auto resume process and during that period of time some connections will fail. The customer is aware of this and has a transient fault handling pattern in place to account for this in their applications. However, the customer is complaining that during this time period they receive what they perceive to be "noise" from Resource Health alerts as connections fail during the auto resume period. I am looking for a way to craft the alert condition to be aware that the database was in a Paused state, so alerts are not sent during this time period.