We have a 5T CIFS share for SQL logging on NetApp AFF300. Application team is complaining after they deleted the data, the available space is not increasing right way. is there any way we can manually refresh the space reclaimation on storage? Snapshot policy is disabled, no existing snapshots.
we are on AFF300, 9.6P5, using aggr volume encryption and thin provisioning.
Once a volume is deleted, it goes into the "volume recovery queue", which is an ONTAP feature that's designed to guard against accidental volume deletions. By default, the volumes exist in the VRQ for 12 hours until they are deleted. This document (below) details the behavior, how to modify it if desired, or how to manually purge the VRQ.
From ONTAP, (like "vol show" or "df") I suspect the answer to this is wait. When a large amount of DELETE is done on a NFS/CIFS share/mount, ONTAP takes some time to update all the free-blocks in the system. It should start freeing pretty quick but in severe cases I have seen upwards of 30-60 minutes to finish.
Are you over-provisioned on the aggregate?
It is possible that the assumed free space was not really there.
Once it was deleted from SQLlog, another volume have "claim" it if it was nearly full.
Might be good to look "storage aggregate show-space" and maybe even "vol show":
set diag ; vol show -sort-by aggregate,volume ; set admin
It's entirely possible where a thin provisioned volume may not see the space if there is a bigger thick volume taking up all the space. We'd need to look at ASUPs to know for sure. If you want feel free to pop open a case and we can take a look.