Kill me

Kill the Bill SPID.

We use sp_who2 to find out all the sesions existing in the server , and to find the blocking SPID we need to execute select * from sys.sysprocesses where spid0; and then kill the Main spid blocking by using KILL , and then to know when is the rollback process complete ? check using KILL with status only; and also we can use SELECT blocking_session_id, *
FROM sys.dm_exec_requests query to find out what is the blocked ids.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s