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.
SQL Server MVP, Consultant, Speaker, Trainer and Learner ;)
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.