溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
-- show blocking SPIDS and SQL SELECT Blocked.Session_ID AS Blocked_Session_ID , Blocked_SQL.text AS Blocked_SQL , waits.wait_type AS Blocked_Resource , Blocking.Session_ID AS Blocking_Session_ID , Blocking_SQL.text AS Blocking_SQL , GETDATE() FROM sys.dm_exec_connections AS Blocking INNER JOIN sys.dm_exec_requests AS Blocked ON Blocked.Blocking_Session_ID = Blocking.Session_ID CROSS APPLY ( SELECT * FROM sys.dm_exec_sql_text(Blocking.most_recent_sql_handle) ) AS Blocking_SQL CROSS APPLY ( SELECT * FROM sys.dm_exec_sql_text(Blocked.sql_handle) ) AS Blocked_SQL INNER JOIN sys.dm_os_waiting_tasks AS waits ON waits.Session_ID = Blocked.Session_ID
Run the above query, it can show blocking SPIDS and SQL for you.
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
