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

![[usp_AnalyzeSpaceCapacity] – SQL Server Space Management Made Easy](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2018/03/%40getVolumeSpaceConsumers_TableResult.jpeg?fit=1024%2C661&ssl=1)