Virtual Log Files VLF Fragmentation

sql-server SQL Server transaction log management why transaction log keeps growing virtual log files VLF fragmentation shrinking transaction log safely ACID transactions in SQL Server

Transaction Log Management

A practical Q&A on SQL Server transaction log internals: how transactions work, crash recovery, why logs grow, and the correct way to shrink and resize the log file.

Jan 12, 2021 · 7 min read