Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Resizing the log file in Simple recovery mode Expand / Collapse
Author
Message
Posted Sunday, April 28, 2013 3:08 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 12:19 PM
Points: 238, Visits: 946
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 ?
Post #1447316
Posted Sunday, April 28, 2013 7:54 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:16 AM
Points: 810, Visits: 1,161
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.
Post #1447324
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse