VLFs in Log Files

Question

VLFs in Log Files

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
January 6, 2011 at 9:09 pm

#231842

Comments posted to this topic are about the item VLFs in Log Files
January 6, 2011 at 11:50 pm

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 52 total)

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Great question, thanks!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 2

Nice one thanks.

Here is an article on this regard with more details:

Managing the Number of VLFs in your Transaction Log[/url]

Regards,

Iulian

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 3

Thank you! I learned something new and I'll take care of this for database maintenance.

😉

DugyC Hall of Fame Points: 3804 More actions · Answer 4

Great question, learnt something new.

After reading the editorial and browsing Kimberly Tripps blog, I found it amusing that the google search first item was... Kimberly Tripps blog... coincidence? 😉 ...somehow I knew the answer would be in there... he he!

_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

grahamc SSCertifiable Points: 6762 More actions · Answer 5

grahamc

SSCertifiable

Points: 6762

January 7, 2011 at 2:45 am

#1270507

Learned something new - thanks

cengland0 SSCertifiable Points: 6102 More actions · Answer 6

cengland0

SSCertifiable

Points: 6102

January 7, 2011 at 3:37 am

#1270533

Awesome question but very difficult.

paul s-306273 SSChampion Points: 10730 More actions · Answer 7

Well, it looks like this is an area not many people know about....

malleswarareddy_m SSCertifiable Points: 5847 More actions · Answer 8

good question,learned some thing new.

Malleswarareddy
I.T.Analyst
MCITP(70-451)

CaioAdachi Old Hand Points: 323 More actions · Answer 9

Good question!

I learned something new. 🙂

Thanks!

TomThomson SSC Guru Points: 104773 More actions · Answer 10

Nice question, but: why would anyone create a 50GB log file in one fell swoop, rather than say making a logfile of 7142 MB and then extending it by that amount 6 times?

Tom

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 11

Good question. I had to do some reading to answer the question. Thanks.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 12

Tom.Thomson (1/7/2011)
Nice question, but: why would anyone create a 50GB log file in one fell swoop, rather than say making a logfile of 7142 MB and then extending it by that amount 6 times?

If you migrated systems, and knew you needed a 50GB log file for a 3TB database, how would you create it? Most people would create a 50TB log file. The log file has to zero out, and so you'd have to sit there to monitor this process otherwise.

Up until this year, that's what I would have done because I had heard too many VLFs were bad. However now I'd go with a smaller amount and extend it.

cengland0 SSCertifiable Points: 6102 More actions · Answer 13

Tom.Thomson (1/7/2011)
Nice question, but: why would anyone create a 50GB log file in one fell swoop, rather than say making a logfile of 7142 MB and then extending it by that amount 6 times?

I would do it. I have databases that get tables updated daily and is around 115 Gigs. I have to backup the database and shrink the logs several times a day or it gets out of hand.

The log files get very large so why not start them out large so it can allocate the space in the beginning without having to autogrow later?