MSSQL Deadlock
SELECT * FROM sys.dm_tran_locks;
SELECT creation_time, total_rows, text
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle)
order by creation_time desc
SELECT
blocking_session_id AS BlockingSession,
session_id AS BlockedSession,
wait_type, wait_time, wait_resource
FROM sys.dm_exec_requests
WHERE blocking_session_id <> 0;
Ulasan