A Little About LOCK_TIMEOUT In SQL Server

Published: 09 December 2024
on channel: Erik Darling (Erik Darling Data)

741

In this video, I delve into the often-overlooked 'LOCK_TIMEOUT' command in SQL Server, addressing common misconceptions and providing practical insights. Erik Darling from Darling Data shares a detailed example where he demonstrates how 'LOCK_TIMEOUT' interacts with query execution plans, revealing that it doesn't check for locks before running the query but rather intervenes when locks are encountered during execution. I also touch on alternative methods to bypass lock issues, such as using read past hints and optimistic isolation levels like 'READ COMMITTED SNAPSHOT'. Whether you're a seasoned SQL Server professional or just starting out, this video offers valuable lessons that can help you better manage concurrency issues in your databases.

CHAPTERS

00:00:00 - Introduction
00:02:14 - Lock Timeout Overview
00:03:02 - Query Plan Analysis
00:06:20 - Lock Timeout Mechanism
00:08:11 - Common Misconceptions

━━━━━━━━━━━━━━━━━━━━━━━━━━
📚 TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-...

SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-...

Learn T-SQL with Erik
https://training.erikdarling.com/lear...

Everything Bundle:
https://training.erikdarling.com/?cou...

━━━━━━━━━━━━━━━━━━━━━━━━━━
🛠️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Need SQL Server performance help?
https://training.erikdarling.com/sqlc...

━━━━━━━━━━━━━━━━━━━━━━━━━━
💬 CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━
Ask questions at Office Hours
https://erikdarling.com/officehours/

Become a channel member
/ @erikdarlingdata
━━━━━━━━━━━━━━━━━━━━━━━━━━

On this page of the site you can watch the video online A Little About LOCK_TIMEOUT In SQL Server with a duration of hours minute second in good quality, which was uploaded by the user Erik Darling (Erik Darling Data) 09 December 2024, share the link with friends and acquaintances, this video has already been watched 741 times on youtube and it was liked by 69 viewers. Enjoy your viewing!