- 查詢死鎖
select
request_session_id spid,
OBJECT_NAME(resource_associated_entity_id) tableName
from
sys.dm_tran_locks
where
resource_type='OBJECT'
- 殺死死鎖進(jìn)程
kill 354
創(chuàng)造死鎖條件
開兩個查詢窗口
BEGIN TRANSACTION--開始事務(wù)
update job set creator='00000' where id='001'
WAITFOR DELAY '02:00';
select * from job where id='001'
