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.

Advertisements

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s