SQL ServerSessions

Kill a session

Ends a session and rolls back its open transaction. A large rollback can take as long as the work did; check progress with KILL <id> WITH STATUSONLY.

Changes data

This script changes the database. Check the names and values before you run it.

b-mssql-kill.sql

1-- Replace 53 with the session_id to end2KILL 53;3 4-- Check rollback progress5KILL 53 WITH STATUSONLY;

Paste it into your query tool.

More SQL Server scripts: Sessions

Currently running requestsEvery user request executing right now, with waits, blocker and the exact statement being run. First stop when someone says the server is slow.