MSSQL Locks
Lock Types
Lock Types
IS (Intent Share)
X (eXclusive)
BU (Bulk Update)
S (data-Share)
SCH_M (SCHema Modify)
Dynamic Management Views
Dynamic Management Views
sys.dm_tran_locksÂ
Bibliography
Bibliography
https://www.brentozar.com/archive/2021/05/free-video-deadlocks-lets-do-one-understand-it-and-fix-it/https://www.littlekendra.com/2017/04/03/which-locks-count-toward-lock-escalation/https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms184286(v=sql.105)https://www.brentozar.com/archive/2021/01/query-hints-you-can-use-to-avoid-blocking/ (NOWAIT)https://www.brentozar.com/archive/2021/01/but-surely-nolock-is-okay-if-no-ones-changing-data-right/ (NOLOCK)https://learn.microsoft.com/en-GB/troubleshoot/sql/database-engine/performance/understand-resolve-blocking