MicrosoftMicrosoftAt present the maximum azure storage available for General purpose tier is 16TB, but the hard limit on the maximum number of data files are still at 280 or this limit has increased? If we have more than 280 data files( with close to 40TB databases in total) then we cant migrate the databases from onpremis to SQL Managed instance general purpose tier? So the option left behind is to go for Azure SQL VM(IaaS)?
Also i noticed that system database files are also allocated with 128GB each where we really dont need this much to be allocated and can provide room for catering other user database data files. Does we have any updated information on this topic?
