Resizing the log file in Simple recovery mode

  • Hi - A brief description of the problem and how it came to be.....

    We have a nightly data load into a reporting db which is set in simple recovery model. This nightly job has suddenly increased in time from 20 mins to over 1hour. I am getting alerts from sql monitor (red gate) stating i have a high number of vlf's in the databases. I noticed the transaction log file was set at 1mb and set to auto grow. I had no idea on how big to set the transaction log so i set it to 10Gb. I watched the job run and kept checking the log size and 500mb seemed to be the max size it grew to.

    So now i need to resize it.

    Will resizing it clear any fragmentation and should i resize it to say 500mb.

    Will this clear the VLF's ?

  • Check this out.

    http://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput

    This article by Kimberly Tripp describes about the VFL management.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply