22-25 April 2026 
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.
Speakers
Chirag Roy's previous sessions
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.
Troubleshooting Transactional Replication in the Wild
Transaction Replication is a widely used feature in SQL Server though its internals are sparsely understood.
In this session we will look under the hood and gain indepth understanding about Transactional Replication architecture and its corresponding components like logreader and distribution agents, Reader/Writer threads, etc. We will learn methods of identifying and monitoring replication latency and methods of troubleshooting and eliminating bottlenecks to improve Replication Performance.