I would like to understand - what happens to Azure SQL Managed Instance when it reached 100% of storage limit ?
Question: Are there any automated process that will run on SQL MI to clean up some space ?
Currently we are using General Purpose Gen5 (8192 GB, 32 vCores)
time storage usage %
2021-04-11 22:00:00.000 95.831251144409179688
2021-04-11 21:00:00.000 95.831251144409179688
2021-04-11 20:00:00.000 100.000011920928955078
2021-04-11 19:00:00.000 100.000011920928955078
2021-04-11 18:00:00.000 100.000011920928955078
No clean up activity was done to make some space available. When I check the per-hour storage usage on our instance, I can see 5% of space got freed up automatically. Can someone help me understand how this happened?
Thanks,
Kishore