1

We would like to receive notifications once the user change SQL Server size from S9 to S12 (increase). Is this possible natively or can we develop custom webhooks to receive notifications?

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30
Jautomator
  • 149
  • 1
  • 9

3 Answers3

3

This action gets logged to the Activity Log. See here. So with this you should be able to create alerts following this tutorial: https://learn.microsoft.com/en-us/azure/azure-monitor/platform/alerts-activity-log

silent
  • 14,494
  • 4
  • 46
  • 86
1

Use the Usage and the RateCard APIs to get estimated cloud consumption and charges. Usage API will get you a metricID which you can use in query using RateCard to predict the price,

https://learn.microsoft.com/bs-cyrl-ba/azure/billing/billing-usage-rate-card-overview

Sample is here

Another Option would be to create custom Azure Policy to audit SQL SKUs and then create an alert once the resource is not compliant with the Azure policy to notify users.

https://learn.microsoft.com/en-us/azure/governance/policy/samples/allowed-sql-db-skus

Anass Kartit
  • 2,017
  • 15
  • 22
0

@silent's answer is probably the best option today. On top of this, you can also use Resource Graph to identify changes: https://learn.microsoft.com/en-us/azure/governance/resource-graph/how-to/get-resource-changes.

Michael Flanakin
  • 472
  • 1
  • 5
  • 18