What impact happens when auto growth is expanding?

  • 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

Leave a Reply

Your email address will not be published. Required fields are marked *