March 20, 2012 at 9:36 am
Hi,
I am currently looking into optimizing the amount of VLFs on a bunch of databases.
I already read:
http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx
http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx
http://www.sqlskills.com/BLOGS/PAUL/post/Bug-log-file-growth-broken-for-multiples-of-4GB.aspx
And searched sqlservercentral.com.
The current amount is ~3700 for a 500G database
and ~800 for a 50G database
These are the two that have the largest database size to VLF count ratio.
From what I read, this is way too much.
How do I determine what amount I need?
I'd expect it to have to do with the size of the log backup (which runs hourly)
Can someone shed some light on it?
Thanks in advance.
March 20, 2012 at 2:39 pm
It has nothing to do with the log backups and everything to do with how the file is grown. Kimberly Tripp's articles are the best I've seen on this topic. Go back through them with a fine toothed comb. They're the 'goto' source for this topic right now. Anything I could tell you about this would be quoting from her.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply