-- Find requests being blocked
SELECT *
FROM sys.dm_exec_requests
WHERE blocking_session_id <> 0;
GO
-- Generate SQL to kill everything blocking session id 85
SELECT distinct 'kill ' +
CONVERT(varchar,blocking_session_id )
FROM sys.dm_os_waiting_tasks
WHERE
session_id = 85;
No comments:
Post a Comment