(Greg Larsen) Generally, you will have no need to worry about the number of virtual log files in your transaction log. However, if you use the default settings for ‘auto-grow’, you can end up with such ‘fragmentation’ in your transaction log as to affect performance noticably.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help