Troubleshooting blocking (Lock waits) in SQL Server
In this session, you will be able to learn how to troubleshoot long running queries due to long LOCK waits, aka blocking, in SQL Server.
Chapters:
0:00 - Introduction
0:17 - Steps to analyze slow running queries
1:35 - Why locks are used in SQL Server?
2:44 - How lock wait occurs?
3:45 - Troubleshooting steps of blocking
4:25 - Live session on blocking: create blocking and troubleshoot in SSMS
9:32 - Main causes of blocking and how to resolve them
Queries used:
https://github.com/Bobirmirzo/blockin...