Blocking FundamentalsUnderstanding BlockingAtomicityConsistencyIsolationDurabilityLocksLock GranularityRow-Level LockPage-Level LockExtent-Level LockHeap or B-tree LockTable-Level LockDatabase-Level LockLock Operations and ModesLock EscalationLock ModesExclusive (X) ModeIntent Shared (IS), Intent Exclusive (IX and Shared with Intent Exclusive (SIX) ModesSchema Modification (Sch-M) and Schema Stability (Sch-S) ModesBulk Update (BU) ModeKey-range ModeLock CompatibilityIsolation LevelsRead UncommittedRead CommittedRepeatable ReadSerializableSnapshotEffect of Indexes on LockingEffect of a Nonclustered IndexEffect of a Clustered IndexEffect of Indexes on the Serializable Isolation LevelCapturing Blocking InformationCapturing Blocking Information with SQLExtended Events and the blocked_process_report EventBlocking ResolutionsOptimize the QueriesDecrease the Isolation LevelPartition the Contended DataRecommendations to Reduce BlockingAutomation to Detect and Collect Blocking InformationSummary