Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore the critical yet often misunderstood component of SQL Server - the transaction log - in this informative 1-hour session from PASS Data Community Summit. Dive deep into the inner workings of transaction logs and learn how to optimize their performance for maximum efficiency. Discover techniques to manage log growth, reduce start-up times, and troubleshoot common issues. Gain insights on determining optimal settings for maximum throughput and effective strategies for handling out-of-control situations. Cover topics including log structure, checkpoints, VLFs, log reuse, and performance improvement techniques. Benefit from expert guidance on identifying transactions and resolving log-related challenges to enhance your SQL Server management skills.
Syllabus
Introduction
Overview
Whats in the Transaction Log
Checkpoint
Transaction Log
VLS
Reusing VLS
DBC Log Info
Troubleshooting Logs
Identifying Transactions
Improving Log Performance
Database Race
Questions
Summary
Taught by
PASS Data Community Summit