- This can cause a performance issue, as this is a blocking operation. The transaction that that initiated the log growth will be held until more space is allocated to the log file, determined by the auto growth setting.
- Physical fragmented on the disk occurs as the pages required are not necessarily next to each other. The more auto-growth events you have the more physical fragmentation you will have the files.
Avoid auto growth by pro actively configuring the auto growth
- Pre-size the data and log files
- Manually manage the growth of data and log files
- Auto growth should be used for safety reasons only