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]

Further Reading

ā€‹Transaction Log Physical Architecture | Microsoft Docs