SQL Server Transaction Log Internals

Presented by: Tim Chapman

Running Time: 82 min

Connections Track: SQL Server

The transaction log plays the most critical role in any SQL Server database. In this session, we discuss the importance of the transaction log and the roles it plays inside the database engine. We look at how logging and recovery work, the checkpoint process, write-ahead logging, and steps you need to take as a DBA to ensure proper management of the transaction log for a SQL Server database.