In this presentation I discuss some of the fundamentals of the SQL Server transaction log and demonstrate a tool that I produced to visualize the transaction log file.
- Slide deck (PDF)
- Scripts
- CorpDB Database (19 MB) used by the scripts. This is a backup from SQL Server 2012. If you restore to 2014 or 2016 be sure to upgrade the compatibility level. Last updated 4 January 2017.
- Log File Visualizer
Presentation History:
- SQL Saturday 542 (St. Louis, Missouri), 10 September 2016
- SQL Saturday 581 (Nashville, Tennessee), 14 January 2017
- SQL Saturday 600 (Chicago, Illinois), 11 March 2017
- SQL Saturday 584 (Colorado Springs, Colorado), 26 March 2017
- SQL Saturday 662 (Sioux Falls, South Dakota), 19 August 2017
- SQL Saturday 631 (Wausau, Wisconsin), 16 September 2017
- SQL Saturday 839 (Virginia Beach, Virginia), 8 June 2019