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