Chirag Roy
sqlking.wordpress.com
Chirag is a Microsoft Certified Master in SQL Server 2008 and works as Senior SQL Server DBA at UBS. He specializes in delivering and maintaining mission and business critical SQL Server solutions.
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.