This is a tough topic. It's a big topic and more than any other – I think there are a lot of misunderstandings about what the log is for, why it's so critical and ESPECIALLY when/why it gets extrememly large. Simply put, it gets large when it's not managed correctly. OK, there are times when [...]
Kimberly L. Tripp
Improving my SQL skills through your questions!
Database Maintenance Best Practices Part III – Transaction Log Maintenance
Posted on: March 14, 2009 2:23 pm
Understanding backups and log-related Trace Flags in SQL Server 2000/2005 and 2008
Posted on: February 13, 2009 4:54 pm
Paul and I started discussing a comment that came up regarding the many issues surrounding logging & recovery. It's one of our favorite topics and in fact was the title to an article that Paul recently wrote for TechNet here: http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx. And, as a sidenote, depending on how much you already know about the transaction [...]
Transaction Log VLFs – too many or too few?
Posted on: November 13, 2008 12:42 pm
(Be sure to join our community to get our monthly newsletter with exclusive content, advance notice of classes with discount codes, and other SQL Server goodies!) Way back in June 2005, I blogged about '8 Steps to better transaction log throughput'. I did this blog post after seeing (again and again) overly fragmented transaction logs… Transaction [...]
8 Steps to better Transaction Log throughput
Posted on: June 25, 2005 11:33 pm
(Be sure to join our community to get our monthly newsletter with exclusive content, advance notice of classes with discount codes, and other SQL Server goodies!) NOTE/UPDATE: Be sure to read this post as well: Transaction Log VLFs too many or too few? after reading this one. Not only can you have too many small [...]
