select distinct request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName
    from sys.dm_tran_locks where resource_type=’OBJECT’

    select distinct wt.session_id, —某个会话
    wait_duration_ms / 1000 as ‘wait seconds’, —等待秒数
    wait_type, —等待类型，可能是进程间的阻塞，也有可能是等待IO完成
    OBJECT_NAME(tl.resource_associated_entity_id) tableName ,
    blocking_session_id, —被这个会话阻塞的，如果有的话

    tl.request_mode, —请求模式，比如S、IX、X
    tl.request_type, —请求类型，比如Lock
    tl.request_status —是否grant

    from sys.dm_os_waiting_tasks wt
    left join sys.dm_tran_locks tl
    on wt.session_id = tl.request_session_id