What is: Detect Virtual Log Files (VLF) in LDF

Multiple small Virtual Log Files commonly known as VLFs together make an LDF file. The writing of the VLF is sequential and resulting in the writing of the LDF file is sequential as well. This leads to another talk that one does not need more than one log file in most cases.

However, in short, you can use following DBCC command to know how many Virtual Log Files or VLFs are present in your log file.


After you execute the above query you can see the column which is marked as 2 which means it is active VLF and the one with 0 which is inactive VLF.