April 28, 2013 at 3:08 am
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 ?
April 28, 2013 at 7:54 am
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