My Azure SQL Database Tips from real life ??
On premium subscription
Restore 1.5 TB database to point in time takes ~ 10 hours
Truncate 100 rows ,100K or 958M rows from table located in azure sql database takes same time ~2 seconds ??
DBCC SHRINKDATABASE will bring DTU to 100% for all execution period (because of I/O operation)
Database Shrink speed ~80 GB/hour
You can minimize impact on application if you shrink 5% at the time
If you start from 1.5 TB allocated space
DBCC SHRINKDATABASE([You db name ],95) --duration -30 min
DBCC SHRINKDATABASE([You db name ],90) --duration -16 min
DBCC SHRINKDATABASE([You db name ],85) --duration -16 min
DBCC SHRINKDATABASE([You db name ],80) --duration -16 min