Tag Archives: SQL Server How to reduce the VLF count

VLF (Virtual Log File) – SQL Server Performance

VLF, Virtual Log File are logical transaction log files which are internally managed by SQL Server. A physical database transaction logs files is divided into multiple virtual log files to manage the WIP transactions. VLF is an internal mechanism for SQL Server to work with the transaction log (mostly for truncation). We should not have [...]