Virtual Log Files (VLFs) are internal divisions of physical log files created by the SQL Server Database Engine. They have no fixed size.
How to Get VLF Count and Size in SQL Server? – Interview Question of the Week #161
Question: How to Get VLF Count and Size Information in SQL Server?
SQL SERVER – PowerShell to Count Number of VLFs in SQL Server
If you are a seasoned DBA, then the conversations and monitoring VLFs is something you are already doing. To learn about the basics of VLF, check my earlier blog at: SQL SERVER – Detect Virtual Log Files (VLF) in LDF. Having a large number of VLFs has a performance impact and there are a number of blogs that discuss the same. As a DBA in this blog I thought of showing a simple script that will help identifying the number of VLFs available inside a SQL Server instance or a number of instances.
SQL SERVER – Reduce the Virtual Log Files (VLFs) from LDF file
Earlier, I wrote a quite note on SQL SERVER – Detect Virtual Log Files (VLF) in LDF. Because of this I got responses suggesting too many VLFs are bad for log file. This prompts to a simple question: “How many is ‘too many’ VLFs?” I suggest that you go and read…
Read MoreSQL SERVER – Detect Virtual Log Files (VLF) in LDF
In one of the recent training engagements, I was asked if it true that there are multiple small log files in the large log file (LDF). I found this question very interesting as the answer is yes. Multiple small Virtual Log Files commonly known as VLFs together make an LDF file.…
Read More