Autogrowth Events
Autogrowth events can impact performance, potentially blocking all access to a database until the growth has completed. Therefore, database growth should be manually managed, but it's sensible to have autogrowth enabled for databases just in case.
Suggested Action
- Monitor data and log files growth and ensure alerts are in place when free space reaches certain thresholds (e.g. <10%).
- Limit the impact of autogrowth events by enabling instant file initialization.
Further Reading
Considerations for the "autogrow" and "autoshrink" settings in SQL Server | Microsoft Support
Database Instant File Initialization | Microsoft Docs
Estimating Disk Space Requirements for Databases | Simple Talk