I want to know the factors that we need to consider in case we need to enable auto-growth settings for my PROD database.
I have already checked the database growth history and the database is growing 1 to 1.5 GB daily on a daily basis(on an average).
Current Database size is 600 GB. Also, I have checked the available free space and we have sufficient space for the files to growth. However, if I set auto growth now to 1 GB, then this space will get filled up after some time.
Please suggest me some more factors that should be taken into account so that I can utilize this available free space effectively and thus eliminate the need for new disk for at-least 10-12 months.