Hi,
My database started consuming disk space. Here is how:
1. run procedure.
2. procedure fails with server crash due to insufficient disk space. It
eats up all the space and crash.
3. restart the database but the disk space remain allocated. All changes
by the procedure are rolled back. There are inserts but not that many to
eat up 10 GB of space. When I check sys.storage, it does not show any
large table.
My guess is that it allocates temporary space and it does not deallocate
it after database start. It deallocates a bit but not everything.
Is there any way how to shrink it manually? It already ate around 40 GB
space. The whole database is around 130 GB so the quick dump and restore
is not possible.
Thank you for any tips,
Radovan Biciste