This video is a brief information about locking in SQL server: what is locking, how many types are there and how do they work.
Agenda:
1. What is locking?
2. Why do we need locking?
3. Major locking types and how they work (with live demo)
To check blocking sessions, use:
SELECT
request_session_id,
resource_type,
resource_description,
request_mode,
request_type,
request_status
FROM sys.dm_tran_locks
SELECT
session_id,
wait_duration_ms,
wait_type,
blocking_session_id,
resource_description
FROM sys.dm_os_waiting_tasks
SELECT
session_id,
status,
wait_type,
wait_time,
wait_resource,
command
FROM sys.dm_exec_requests
📚 ►Full course on Troubleshooting sessions: [ Ссылка ]
📷 ►Follow me on Instagram - [ Ссылка ]
🧑💼►Follow me on LinkedIn - [ Ссылка ]
Watch all my playlists here:
🚀►Full course on Encrypting connections to SQL Server- [ Ссылка ]
🚀 ►SQL Server replication session: [ Ссылка ]
🚀 ►SQL Server Always On Availability Group: [ Ссылка ]
🚀 ► SQL Server internals: [ Ссылка ]
🚀 ► Course in On-memory OLTP: [ Ссылка ]
Ещё видео!