Latching and latch contention in SQL Server
In this video, I am going to talk about latching. I will explain what is latching, why it is taken and what kind of types are there. I will also talk about how latch contention will happen.
You will learn about PAGEIOLATCH, PAGELATCH and LATCH latches and why and in what cases they are taken.
Chapters:
0:00 - Introduction
0:20 - What is latching and why we need it?
3:00 - Latch modes
4:24 - Latch contention
📚 ►SQL Server internals: • SQL Internals
📷 ►Follow me on Instagram - https://www.instagram.com/arslanov_bo...
🧑💼►Follow me on LinkedIn - / bobirmirzo-arslanov-548960173
Watch all my playlists here:
🚀►Full course on Encrypting connections to SQL Server- • Full course on Encrypting connections...
🚀 ►SQL Server replication session: • SQL Server replication
🚀 ►SQL Server Always On Availability Group: • SQL Server Always On Availability Gro...
🚀 ► Full course on Troubleshooting sessions: • Troubleshooting
🚀 ► Course in On-memory OLTP: • Course on In-Memory OLTP