I am using Azure SQL Database with 10gb of storage (Standard S2: 50 DTUs). I am running a process where I am deleting all rows in a table every 6 hours and recreating and loading table from our business system. What I am noticing is that although the data in our source isn't getting exponentially larger it seems the database is getting larger at a higher speed. I am wondering if azure SQL when dropping and recreating stores even though its deleted and counted against your total storage?

Thanks for any help on this.

CodePudding user response：

Please defrag all indexes. As mentioned on

The options are two:

1. The stored procedure that is supposed to delete the data is not deleting data or is deleting less data
2. More data are ingested since the 13 of December