Auto alert when compute tier of Azure SQL is changed

mo boy 396 Reputation points
2020-10-25T11:02:58.84+00:00

Dear Experts,

Is there any way we can set up automated alerts whenever compute tier of an Azure SQL DB is changed from say S3 to P2 compute tier?

I tried setting up alerting and came across 'Create/Update Azure SQL database' in Signal logic.

I do get an email when the compute tier is changed but doesn't look like I am using the correct one.

Is there any custom alerting I can configure? Please provide your suggestions.

Thanks

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator
    2020-10-31T00:18:34.837+00:00

    @mo boy

    Want to convey we did check and found the alert for create/update is not very informative about the SKU change. But we also saw the activity log of a database logs the change for the SKU change.
    36502-image.png

    We are trying to check if this can used somehow to achieve what you want to do.

    We appreciate your patience in this regard.

    Regards
    Navtej S


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.