MSSQL 2016每几天死锁一次。
执行:
SELECT sqltext.text,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time,
req.blocking_session_id
FROM sys.dm_exec_requests req (NOLOCK)
CROSS APPLY sys.dm_exec_sql_text(req.sql_handle) AS sqltext
通过blocking_session_id 发现阻塞session最终矛头都指向是session 134。
但是session 134的状态是suspended,正常不是应该状态是running才可能是阻塞根源的session吗?