Successful Logging for real Timber entails meticulous planning, acute selection, proper process and flawless execution which are all important to produce best returns. Transaction Log files in SQL Server are an extremely important component requiring careful planning for the correct sizing, careful implementation and acute management to keep the cogwheels of SQL server well oiled and chugging away to extract the best performance out of the system.

This session is filled with demos of real world samples starting with analysing the core structure of Transaction Log files and the role it plays in the different working scenarios. We will delve further into the role of Transaction Log file in planning on how to correctly size them, engineer manageable VLF's, choosing the correct recovery model and the intricacies of transaction log file usages with respect to checkpoint, snapshots, replication, crash recovery, database  backups, database mirroring and change data capture. We will deep dive into recovering from lost log files, a peculiar case of runaway tempdb log file and resolution, troubleshooting autogrowing log files. So bring out your chainsaws, sharpen your blades and get ready to start Logging the right way!

Presented by Chirag Roy at SQLBits VI
Slide Deck 3.5 MB
WMV Video 200 MB