Server level VLF report - Andrew Calvett

Server level VLF report

Published Wednesday, July 25, 2007 11:27 PM

This blog has been migrated to blog.calvett.co.uk. Please update your feeds.
This post can be found here.

Filed under: , ,

Comments

# tonyrogerson said on Thursday, July 26, 2007 7:39 AM

Very useful Andrew - definitely be using that in the future - thanks.

My entry on VLF came from last weeks user group evening where somebody mentioned it was actually good to have lots of VLF's and use the default autogrowth settings - I just had to show that was wrong.

See you tomorrow evening at the SQLBlogsters meal!

Tony

# GrumpyOldDBA said on Thursday, July 26, 2007 10:04 AM

Paul Randal covered this in April this year " crucial database main..." , sure you were there Tony ????? It can be quite difficult to bring this figure down on a production database - sometimes the only way is to actually remove the log file / drop the database into simple - not an easy task if your database is large or is almost 7 x 24. Paul indicated any figure over 50 was bad as far as I can remember.