Azure SQL Managed Instance enables you to choose the amount of storage that you need. You would need to monitor your database to see if you have enough storage to operate and take some corrective actions if you are reaching the storage limit. In addition, there are some constraints that Managed Instance introduces and technical/architectural characteristics that might affect your workload.
If you are getting errors related to storage and file management, here are some actions that might help you to troubleshoot and solve the issues:
select top 1 start_time, storage_space_used_mb, reserved_storage_mb, [storage usage %] = 100 * (storage_space_used_mb/reserved_storage_mb) from master.sys.server_resource_stats order by start_time desc
select [time] = DATEADD(hour, DATEDIFF(hour, 0, start_time), 0), [storage usage %] = 100 * max(storage_space_used_mb/reserved_storage_mb) from master.sys.server_resource_stats group by DATEADD(hour, DATEDIFF(hour, 0, start_time), 0) order by DATEADD(hour, DATEDIFF(hour, 0, start_time), 0) desc
Try to identify a query or process that causes peaks in the storage usage - for example REBUILD INDEX that fills the log file, a big ETL process that loads a huge amount of data, etc.
select tempdb_size_gb = sum(size*8./1024/1024/1024) from master.sys.master_files where db_name(database_id) = 'tempdb' and type_desc = 'ROWS'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.