Do I Want to Design My Own Transaction Log?

The processing of the Transaction Log seems simple to reproduce, but be sure you consider all the possibilities.

Transaction Log VLF Alarm

This was used to alert on VLF counts to high due to replication log reader having issue reading the transaction log.

Display Transaction Log Size

Stored procedure to display transaction log size for select databases.

What SQL Statements Are Currently Using The Transaction Logs?

This article presents a utility that will show you what SQL statements are using the transaction logs, in terms of log space used and transaction duration.

Questions About SQL Server Transaction Log You Were Too Shy To Ask

Tony Davis answers 10 surprisingly tricky questions about SQL Server Transaction Log.

Optimizing Transaction Log Throughput

As a DBA, it is vital to manage transaction log growth explicitly, rather than let SQL Server auto-growth events "manage" it for you. If you undersize the log, and then let SQL Server auto-grow it in small increments, you'll end up with a very fragmented log. This article demonstrates how this can have a significant impact on the performance of any SQL Server operations that need to read the log.

Avoid Transaction Logs volume from filling

Script for preventing the volumes of the transaction logs from filling.

Minimum Number of VLFs

Right or Wrong, Dynamic SQL AND a Cursor

I'm no big fan of dynamic SQL or cursors, however there are times where they do the job.

Manual cleanup Change Data Capture for a SQL Server database

Kun Lee had a database where the log file kept growing and used 99.99% of the available space. He noticed miscellaneous change data capture objects still in the database as well as open transactions. This was causing his transaction log to continue to grow, but he couldn't disable CDC, because SQL Server thought it was not enabled. Read the full article to see his solution.