Adding a second log file feels like a speed fix, but it is only a spare room. Here is how to watch it work and how to retire it.
SQL SERVER – Reduce the Virtual Log Files (VLFs) from LDF file
Too many virtual log files are bad for your LDF. Here is a simple script to reduce the virtual log files right away with a log backup and a shrink.
SQL SERVER – Detect Virtual Log Files (VLF) in LDF
A large LDF file is made of many small Virtual Log Files (VLFs). Here is how to detect them with DBCC LOGINFO and see which ones are active.
Monitoring Log Growth and VLF Counts
Monitor VLF counts and transaction log growth with SQL Server DMVs, then choose file growth settings that keep recovery and maintenance predictable.



