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: • Troubleshooting
📷 ►Follow me on Instagram - www.instagram....
🧑💼►Follow me on LinkedIn - / bobirmirzo-arslanov-54...
Watch all my playlists here:
🚀►Full course on Encrypting connections to SQL Server- • Full course on Encrypt...
🚀 ►SQL Server replication session: • SQL Server replication
🚀 ►SQL Server Always On Availability Group: • SQL Server Always On A...
🚀 ► SQL Server internals: • SQL Internals
🚀 ► Course in On-memory OLTP: • Course on In-Memory OLTP
14 окт 2024