SQLBits 2011

Transaction Log Performance & Troubleshooting-Deep Dive

In this session we will take a deep dive into gaining an understanding of things that can affect transaction log performance and look into methods of prevention and troubleshooting of everyday gremlins.
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.