This blog has been migrated to blog.calvett.co.uk. Please update your feeds.This post can be found here.
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!
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.