잠금정보 확인

SELECT resource_type, resource_database_id, resource_associated_entity_id, request_mode
FROM sys.dm_tran_locks