The Transaction Log is one of the most important objects in the SQL Server database architecture. In this session we will take a deep dive into gaining an understanding of things that can affect transaction log performance. We will venture into methods of prevention and troubleshooting of everyday gremlins through correctly size them, engineering 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.
Slide Deck 1.1 MB , MP4 Video Low 53 MB , MP4 Video Med 78 MB , MP4 Video High 174 MB , MP4 Video HD 333 MB