How to Setup Alert on Azure SQL MI instance for % storage space used?

Question

We need to setup Alert if 80% of space used by Azure SQL MI instance then it should be alerted. In existing Alert metrics not provide option to use value in percentage(%). So anyone have any idea how we can setup alert on % space used by azure mi?

score 1 · Answer 1 · answered Feb 07 '23 at 12:23

1

As of now, the available options for setting alerts for managed instance are below only as mentioned in document,

Average CPU percentage
IO bytes read
IO bytes written
IO requests count
Storage space reserved
Storage space used
Virtual core count Storage alerts are available as of now are in count format only. Percentage is not available by default from azure. If you want to calculate available space in sql MI refer this so thread

answered Feb 07 '23 at 12:23

vijaya

1,525
1
2
6

Thank you Vijaya. I knew count format but is there any way we can raise alert using % format? – NP007 Feb 08 '23 at 09:27
As of now there is no direct way to get alert when SQL MI storage is greater than 80% – vijaya Feb 08 '23 at 10:36

score 1 · Accepted Answer · answered Jul 27 '23 at 11:33

If you have defined diagnostic settings such that the SQLMI sends its metrics to a log analytics workspace, you can use a log search alert:

AzureMetrics
| extend p = pack(MetricName, Average)
| summarize bag = make_bag(p) by TimeGenerated
| evaluate bag_unpack(bag)
| extend reserved_storage = reserved_storage_mb
| extend used_storage = storage_space_used_mb
| extend storage_used_percentage = round(100.0 * used_storage / reserved_storage)
| project TimeGenerated, storage_used_percentage, reserved_storage, used_storage
| where storage_used_percentage >= 80

How to Setup Alert on Azure SQL MI instance for % storage space used?

2 Answers2

Linked