Tag Archives: How to check Number of VLF for all databases

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 [...]