Database File Auto Growth
Database free space should be monitored and maintained but, should the worst happen, having autogrowth enabled with a practical value will help to improve the overall performance of the instance and reduce fragmentation.
The default values are inadequate for most databases and can cause performance issues. Therefore we recommend the following settings:
|Database Size||Warning Size||Recommended Size|
Enable autogrowth and configure the growth to the recommended value.
Any suggestion from Aireforge should be thoroughly tested before being implemented into production.
Considerations for the "autogrow" and "autoshrink" settings in SQL Server | Microsoft Support
SQL Server Database Growth and Autogrowth Settings | Simple Talk
Database Instant File Initialization | Microsoft Docs