The full form of DBCC is Database Console Commands.
The dbcc loginfo commands tells that how many VLFS(Virtual Log Files) are created in our database.
The number of VLF’S are created based on the size of log file(.ldf).
Basically how many number of VLF’S are created it depends on the following simple algorithm. The logic behind that algorithm is,
- If log file size <=1MB ——-> 2 VLFS are created.
- If log file size > 1MB and <=64MB ——-> 4 VLFS are created.
- If log file size >64 MB and <=1GB ——–> 8 VLFS are created.
- if log file size >1GB ——–>16 VLFS are created.
The following screenshot it will clearly tells how many number of VLFS are created on particular database.