Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Turbo Charged Transaction Logs

PASS Data Community Summit via YouTube

Overview

Explore the critical yet often misunderstood component of SQL Server - the transaction log - in this informative 1-hour session from PASS Data Community Summit. Dive deep into the inner workings of transaction logs and learn how to optimize their performance for maximum efficiency. Discover techniques to manage log growth, reduce start-up times, and troubleshoot common issues. Gain insights on determining optimal settings for maximum throughput and effective strategies for handling out-of-control situations. Cover topics including log structure, checkpoints, VLFs, log reuse, and performance improvement techniques. Benefit from expert guidance on identifying transactions and resolving log-related challenges to enhance your SQL Server management skills.

Syllabus

Introduction
Overview
Whats in the Transaction Log
Checkpoint
Transaction Log
VLS
Reusing VLS
DBC Log Info
Troubleshooting Logs
Identifying Transactions
Improving Log Performance
Database Race
Questions
Summary

Taught by

PASS Data Community Summit

Reviews

Start your review of Turbo Charged Transaction Logs

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.