sql 查询阻塞

use PhoneHelp
go
select
   trl.resource_type,
   trl.resource_subtype,
   trl.resource_database_id,
   trl.resource_associated_entity_id,
   trl.request_mode,
   trl.request_type,
   trl.request_status,
   trl.request_session_id,
   trl.request_owner_type,
   tr2.blocking_session_id
   from sys.dm_tran_locks as trl
   inner join sys.dm_os_waiting_tasks as tr2
   on trl.lock_owner_address=tr2.resource_address