Posted inPerformance Tuning TSQL
Get Rid of High VLF Easily
Remove High Virtual Log File (VLF) (@OptimizeLogFiles)
This generates TSQL code for removing huge virtual log files (VLFs) from SQL Server database log files. By default, @vlfCountThreshold is 500. So any log file with VLF count greater than @vlfCountThreshold will be considered for SHRINKFILE operation, Regrow to original Size in appropriate size chunk, and finally reset the AutoGrowth settings.
Space-Capacity-Automation url:-
https://github.com/imajaydwivedi/Space-Capacity-Automation