suspended sql solution.sql

SELECT 
    s.session_id,
    s.login_name,
    s.host_name,
    s.status,
    s.last_request_start_time,
    s.last_request_end_time,
    r.cpu_time,
    r.total_elapsed_time,
    r.reads,
    r.writes
FROM sys.dm_exec_sessions s
LEFT JOIN sys.dm_exec_requests r ON s.session_id = r.session_id
WHERE s.session_id = 69;  -- Replace with the actual session ID
 
kill 69;