-3

We have killed a specific query but still is running in background. How can we kill permanently. It's urgent.

Regards Debajit

1
  • It's running not more! You killed the wrong spid or it's merely being rolled back, what for an intense UP/DEL/INS long running one can take a while.
    – jean
    Commented Jun 5, 2017 at 16:29

1 Answer 1

2

First execute the below command:

sp_who2 'active'

Check values under CPUTime and DiskIO. Note the SPID of process having large value comparatively.

After that execute the below command with SPID, which you got from above command:

kill {SPID value}

2
  • 3
    Just a few notes to add, there is a chance they will see it stuck in killed/rollback after this occurs. Shanky_621 had the resolution for that, there are other resources online that suggest similar fixes if that occurs. Commented Jun 5, 2017 at 15:57
  • 2
    @Debajit, could you please tell us after killing Session did you see any error message or result? for an Example (SPID 57: transaction rollback in progress. Estimated rollback completion: 80%. Estimated time remaining: 10 seconds)
    – CR241
    Commented Jun 5, 2017 at 16:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.