What is vlf in sql server?


Upload Image

Report Form

Question: What is vlf in sql server?

Topics: server

Paste old question below.

Available Answers: 1

Answer #1#


SQL Server internally manages the Log file into multiple smaller chunks called Virtual Log Files or VLFs. Each physical transaction log file is divided internally into numerous virtual log files, or VLFs. VLF stands for Virtual Log File and the transaction log file is made up of one or more virtual log files. This entry was posted in SQL Server. As we all know, Transaction Log Files are internally divided into small virtual log files called VLF/VLFs. If the next growth is less than 1/8 of current log physical size, then create 1 VLF that covers the growth size (Starting with SQL Server 2014 (12.


Answered By:


Kozhikode, India

Only Logged in users can post reply.

More Questions


Lost Password!

Create Account

Wait Processing...