Description

גיא ואיתן מדברים על העולם המופלא של הנעילות ב-SQL Server ואיך להתמודד איתו.

קישורים רלוונטיים:

• Transaction locking and row versioning guide - SQL Server | Microsoft Learn
• sys.dm_tran_locks (Transact-SQL) - SQL Server | Microsoft Learn
• sys.dm_os_waiting_tasks (Transact-SQL) - SQL Server | Microsoft Learn
• SET LOCK_TIMEOUT (Transact-SQL) - SQL Server | Microsoft Learn
• Accelerated database recovery - SQL Server | Microsoft Learn
• microsoft-dbas-club/Diagnostics/Head Blockers.sql
• microsoft-dbas-club/Diagnostics/Sleeping Sessions with Old Open Transactions.sql
• sys.dm_tran_active_transactions (Transact-SQL) - SQL Server | Microsoft Learn
• sys.dm_tran_session_transactions (Transact-SQL) - SQL Server | Microsoft Learn
• sys.dm_exec_connections (Transact-SQL) - SQL Server | Microsoft Learn
• sys.dm_exec_sql_text (Transact-SQL) - SQL Server | Microsoft Learn
• microsoft-dbas-club/Diagnostics/Session DMVs - sp_who3.sql
• microsoft-dbas-club/TempDB/Identify Tempdb Contention.sql
• Blocked Process Report Event Class - SQL Server | Microsoft Learn
• DarlingData/sp_HumanEvents/sp_HumanEventsBlockViewer.sql