Query para identificar sesiones bloqueadas

USE DB_PRUEBA
GO
SELECT session_id,
blocking_session_id,
wait_time,
wait_type,
last_wait_type,
wait_resource,
transaction_isolation_level,
lock_timeout
FROM sys.dm_exec_requests
WHERE blocking_session_id <> 0
GO

Matar todas las conexiones a una base:

declare @kill varchar(8000)=»;
begin
select ‘kill ‘+ CONVERT(varchar(5),session_id) + ‘;’
from sys.dm_exec_sessions where database_id = db_id(‘DB_PRUEBA’);
exec(@kill);
end;