podcast
details
.com
Share
שיחות בין DBAs
פרק 173 - נעילות וצרות אחרות
Listen
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
podcast
details
Print
Share
Want to check another podcast?
Enter the RSS feed of a podcast, and see all of their public statistics.
Check it
Made by
Alex Barredo
. Send your feedback to
alex@barredo.es
.