MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server: Logging, Recovery, and the Transaction Log

Course Summary

The logging and recovery mechanism is one of the most misunderstood parts of SQL Server, but it's one of the most critical for you to understand. There are a lot of log management problems you can run into that can cause workload performance problems and

  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Problems From Misconceptions
        ◦ Course Structure
    ● Understanding Logging
        ◦ Introduction
        ◦ Basic Terminology
        ◦ Why is Logging Required?
        ◦ Where are Logging and Recovery Used?
        ◦ Where are Logging and Recovery Used? (2)
        ◦ Write-Ahead Logging
        ◦ Example Data Modification
        ◦ First Steps: Reading and Initial Locking
        ◦ What It Looks Like: Initial Locking
        ◦ Next Steps: Changing and Logging
        ◦ What It Looks Like: Modifications
        ◦ Next Steps: Committing the Changes
        ◦ What It Looks Like: Committing
        ◦ The Transaction Has Committed - Now What?
        ◦ Summary
    ● Transaction Log Architecture
        ◦ Introduction
        ◦ Creating or Growing a Transaction Log File
        ◦ Demo: Transaction Log File Zeroing
        ◦ Virtual Log Files
        ◦ How Many VLFs Do You Get?
        ◦ VLF Sequence Numbers
        ◦ VLFs and Log Blocks
        ◦ VLFs and Log Blocks (2)
        ◦ Log Sequence Numbers (LSNs)
        ◦ DBCC LOGINFO
        ◦ Demo: DBCC LOGINFO
        ◦ Summary
    ● Log Records
        ◦ Introduction
        ◦ What are Log Records?
        ◦ Log Record Contents
        ◦ Log Space Reservation
        ◦ Log Record Types
        ◦ Lock Logging
        ◦ Log Records in Transactions
        ◦ Examining Log Records
        ◦ Demo: Examining Log Records
        ◦ Modifying Row Contents
        ◦ Modifying Row Contents (2)
        ◦ Demo: Modifying Row Contents
        ◦ COMPENSATION Log Records
        ◦ Rolling Back a Transaction
        ◦ Demo: COMPENSATION Log Records
        ◦ Rollbacks and Differential Backups
        ◦ Log Record Patterns of Interest
        ◦ Demo: Table Creation Pattern
        ◦ Demo: Index Root Page Creation Pattern
        ◦ Demo: Index Page Split Pattern
        ◦ Demo: Ghost Records Pattern
        ◦ Tempdb Behavior
        ◦ Summary
    ● Checkpoints
        ◦ Introduction
        ◦ Why Do Checkpoints Exist?
        ◦ Clean vs. Dirty Pages
        ◦ Demo: sys.dm_os_buffer_descriptors
        ◦ Checkpoint Mechanism
        ◦ Checkpoint Mechanism (2)
        ◦ Checkpoint and the Log
        ◦ Checkpoint Log Records
        ◦ Demo: Checkpoint Log Records
        ◦ Automatic Checkpoints
        ◦ Indirect Checkpoints
        ◦ Internal Checkpoints
        ◦ Manual Checkpoints
        ◦ Checkpoint Monitoring
        ◦ Demo: Monitoring Checkpoints
        ◦ Tempdb Behavior
        ◦ Summary
    ● Transaction Log Operations
        ◦ Introduction
        ◦ Making a VLF Active
        ◦ Log Space Reservation
        ◦ Moving Through the Transaction Log
        ◦ Tracking Uncommitted Transactions
        ◦ Demo: Tracking Uncommitted Transactions
        ◦ Transaction Log Clearing
        ◦ Tracking Transaction Log Space Usage
        ◦ Circular Nature of the Transaction Log
        ◦ Wrapping with Multiple Files
        ◦ Demo: Circular Nature of the Transaction Log
        ◦ If the Transaction Log Fills Up...
        ◦ Why Did the Transaction Log Fill Up?
        ◦ Demo: Full Transaction Log
        ◦ Demo: Runaway Transaction Log

    Course Fee:
    USD 29

    Course Type:


    Course Status:



    1 - 4 hours / week

    This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top