Over the last 2 years I have been working with multiple clients and one of the common situations which I observed when dealing with prebuilt script(Application setup scripts) is having an additional log file(ldf) getting created during initial database setup.

This additional log file is created mostly with a wrong assumption that it will improve performance. I would like to clarify this concept using this blog post.

Adding additional log file will never gain you performance as log records are written sequentially to the transaction log.

Adding an additional log file in a different drive during an event where the initial file is full and you don’t have enough space on the disk to allow growth is acceptable.