I have 1.8TB AX database.
File Size : 1851427.75 MB
Free Space : 502837.13 MB
If free spaces will be used in the future, I don't want to shrink. Because it's taking a long time. (and index fragmentation)
Daily observations result:
- Day Free space 492.435,75 MB (26%)
- Day Free space 485.750,25 MB (26%)
- Day Free space 502.875,75 MB (27%)
Sometimes the free space is reduced, sometimes data file size grows.
Why there is growth when there is free space, how SQL decides?