SqlServer 数据库死锁查询sql,sql死锁查询语句

SqlServer 数据库死锁查询sql select        request_session_id spid,       OBJECT_NAME(resource_associated_entity_id) tableName    from        sys.dm_tran_locks   where        resource_type='OBJECT'