sql 锁定 查询

select *,
t1.resource_type  ,t1.resource_associated_entity_id   ,t1.request_mode   from
 sys.dm_tran_locks as t1,
 sys.dm_os_waiting_tasks as t2
where
 t1.lock_owner_address = t2.resource_address

select object_name('709577566')

-- Simple query to return all records and all columns
SELECT *
FROM master.sys.dm_tran_locks;
GO
-- Focused result set
SELECT resource_type, request_session_id, resource_database_id, resource_associated_entity_id, resource_subtype, resource_description, request_status, request_owner_type, request_mode
FROM sys.dm_tran_locks;
GO

-- Number of lock records per database
SELECT COUNT(*) AS 'NumberofLockRecords', DB_NAME(resource_database_id)
FROM master.sys.dm_tran_locks
GROUP BY resource_database_id;
GO

-- Query for specific lock types
SELECT resource_type, request_session_id, resource_database_id, resource_associated_entity_id, resource_subtype, resource_description, request_status, request_owner_type, request_mode
FROM sys.dm_tran_locks
WHERE resource_type IN ('PAGE', 'KEY', 'EXTENT', 'RID');
GO

SELECT tl.request_session_id, wt.blocking_session_id, DB_NAME(tl.resource_database_id) AS DatabaseName, tl.resource_type, tl.request_mode,object_name(tl.resource_associated_entity_id )
FROM sys.dm_tran_locks as tl
INNER JOIN sys.dm_os_waiting_tasks as wt
ON tl.lock_owner_address = wt.resource_address;
GO

kill 66
select object_name(709577566)

SELECT resource_type, request_session_id, resource_database_id, object_name(resource_associated_entity_id), resource_subtype, resource_description, request_status, request_owner_type, request_mode

FROM sys.dm_tran_locks;