SQL Database capacity consumption too high !
I'm copying a few massive tables from an On-prem SQL Server Database into a Fabric SQL Database. Tables are around 1.6TB, 1.3TB and 1.1TB, and there are more smaller tables as well. The Database has reached maximum allocated size and I've stopped copying two days ago. One of the batches abruplty stopped during load. It is still consuming a LOT of CUs ! I'm aware of how even after the copy data activity has stopped there's prolonged capacity consumption (apparently for indexing, statistics etc) but this is a slightly higher percentage of base capacity than what I've seen before and its been going on for much longer than before. Could this be because of the size of the item (~3416 GB) ? Also, is there any way to suppress this without having to wait until it dies out, whenever that it. I cannot apply the per-database max vCore setting (as proposed in this solution) because of the size.
