We use Local Storage to store up to two years worth of data for our monitoring services. As a consequence we have an automation that steps through all the tables deleting any data that is more than two years old.
Although I can see that the number of rows is being reduced the amount of space on the drive isn’t changing.
Does TDP release space at any point?
Is there a way of forcing Local Storage to release unused space?
If not, at some point, we will run out of space on the drive we are using!