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 ?