Check out the solution in the video TSQL: Get Number of VLFs. We see how to get the number of VLFs in a database within SQL Server. This is worth considering from time to time, as it may indicate that you need to review your configurations. For larger environments, you may want to track this information over time, as you may not always have the time to dig into this.
Check out the highest-rated Automating ETL course on Udemy, if you're interested in data.
Should you use alerting with these? Maybe, but we have to consider alerting best practices before we rush off and create alerts. I don't view VLFs as a big enough deal in most cases for alerts, but a good review to see how your log sizing and growth are performing. I always prefer to pre-grow logs.
YouTube | Automating ETL | T-SQL In 2 Hours | Consumer Guide To Digital Security