Multiple Log Files
Database log files are always written to sequentially, so there's no performance benefit to be gained by having more than one log file per database.
Suggested Action
š” Aireforge Advisor can automatically generate a script for this.
Remove the extra log files if they're no longer required or used.
How to drop a secondary log file in SQL Server
ALTER DATABASE [WhippetWorks] REMOVE FILE [WhippetWorks_log_2]
GO
Further Reading
āTransaction Log Physical Architecture | Microsoft Docs