I'm investigating a database with a large transaction log. Looking at DBCC Loginfo I can see the database has 1200 VLF's, which is on the high side but not terribly concerning. What does worry me though is one one the VLF's is 13GB.
The majority of the VLF are 100mb (the autogrow size), which should probably be higher.
Is there a way to get rid of this large VLF and what the implications of having such a large VLF.
This is on SQL 2017 enterprise edition and the database in question is in an AG