When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.
2020-04-01 (first published: 2013-08-14)
Why does the transaction log fill up? There are a variety of reasons, and MVP Gail Shaw walks you through the various things to check.
2012-08-31 (first published: 2011-02-21)
This article shows how you can read the [RowLog Contents] in the Transaction Log, for Real!
2012-11-09 (first published: 2010-11-22)
This SP will monitor T-Log space and sends mail to DBA if log space usage is above threshold value
2010-10-05 (first published: 2010-10-03)