Detecting and Reducing VLFs in SQL Server 2008/2008 R2 Transaction Log Files | Glenn Berry's SQL Ser

One common, but often undetected issue that I see with SQL Server databases is a very high number of virtual log files (VLFs) inside the SQL Server transaction log file. This usually occurs because the default initial size and autogrowth increment are bot

sqlserverperformance.wordpress