Adding additional log file to improve performance – Common Misconception

 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.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s