MSSQL中如何查看行锁等待？

可以使用如下SQL语句，查看当前实例的行锁等待情况。 use master; go WITH CTE_SID ( BSID, SID, sql_handle )        AS ( SELECT [Blocking_Session_ID], [Session_ID] , sql_handle FROM     sys.dm_exec_requests WHERE    [Blocking_Session_ID] <> 0 UNION ALL SELECT   A.[Blocking_Session_ID] , A.[Session_ID] , A.sql_handle FROM     sys.dm_exec_requests A JOIN CTE_SID B ON A.[Session_ID] = B.BSID ) SELECT C.BSID, C.SID , S.login_name , S.host_name , S.status , S.cpu_time , S.memory_usage , S.last_request_start_time , S.last_request_end_time , S.logical_reads , S.row_count , q.text FROM CTE_SID C JOIN sys.dm_exec_sessions S ON C.sid = s.[Session_ID] CROSS APPLY sys.dm_exec_sql_text(C.sql_handle) Q ORDER BY sid