Transaction Log Performance Tuning, Stop shouting Timber!

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
  • Downloads
    Slide deck available Slide Deck 3.5 MB
    Video available WMV Video 200 MB
  • SpeakerBIO

    Chirag is a Microsoft Certified Master in SQL Server 2008 and works as Senior SQL DBA at Coeo Ltd. Coeo are a Microsoft Gold Partner providing SQL Server consulting and Remote DBA services to customers who outsource management and 24x7 operations of their SQL Server platform.  Chirag specializes in delivering and maintaining mission and business critical SQL Server solutions for customers in a variety of industry sectors throughout Europe.

    Prior to joining Coeo, Chirag worked for two years with the Totaljobs Group Ltd as SQL DBA Team Lead. He managed a highly successful high pressure operation's DBA team which managed over 30 production servers 24x7. He was responsible for looking after the health of the SQL environment and manage various database projects involving troubleshooting, performance tuning, monitoring, optimization, high availability, disaster recovery, replication, clustering, version upgrades and migration. He has worked with SQL Server since 1999 from SQL 6.5 to SQL 2008 R2 with industries like online travel brands, online job boards, garment manufacturing, debt collection, and teaching.

    Chirag currently also holds the MCITP: Database Development and Administration for SQL 2005/2008 and MCDBA:SQL 2000 certifications.
  • Video