Local Storage - Freeing up space

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!

You need to run Optimize Table.


Thanks Debbie - as always spot on!