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.

Leave a Reply