Suspended Processes on SQL and How to KILL Them : Sessions

Suspended Processes on SQL and How to KILL Them Print

Modified on: Fri, 3 Jun, 2022 at 1:47 PM

Open SQL Management Studio.

Click NEW QUERY

Type sp_who2

Click EXECUTE

On the results, scroll down to the bottom and find the very last suspended process and notate the SPID for example:

Click NEW QUERY

Type KILL 145

Repeat the process until no more suspended processes are visible.

Did you find it helpful? Yes No

Help Desk Software by Freshdesk