Best Practices

Best Practice No.36

Do proper capacity planning for the growth of your Transaction log file and size them accordingly – don’t leave it to Auto-grow on default setting to avoid performance hit.

Transaction Log files cannot take advantage of Instant File Initialization.