It is not good practice to keep the “In Percent” File Growth option for database files. If the“In Percent” option is used for any database file and if the file size is very big, it may cause performance degradation during the file growth phase.It is recommended to keep 1024MB for data files and 256MB for log files. Log files are really important because when the transaction occurs, it is written to memory and log files first.
To enable the autogrowth first right-click on Database, click on Properties, and click on Files. There will be a column of Autogrowth, click on small box with three (…) dots.
![]()