We are in process of migrating our datawarehouse from Azure SQL VM to Azure Managed instance. I have a table with exact same table strutcure, data and index with about 35 M records in both places.

The Sql VM has compression type: Page and it is occupying about 4GB in space.

But Azure MI ( don’t know how to automate compression here) is occupying 48GB.

Similarly indexes are taking more space as well.

Any suggestions or help will be appreciated here. We don’t want to scale up beyond where we are at.

MI is set at
Next Gen Service Tier
Compute is Premium with 16 core
Disk space: 16 TB.

Using synapse to load from data ADLS gen2 to Azure MI.

Is there any obivous setting in MI that we missed?