Scribd
Upload
26 views1 page

Kill Blocking Negative SPID in SQL Server

This document provides instructions for killing a blocking negative SPID in SQL Server. It involves running a query on the sys.dm_tran_locks dynamic management view to find the request_owner_guid of the blocking SPID. It then uses the KILL command to terminate the session associated with that GUID value, removing the block.

Uploaded by

mano555
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
26 views1 page

Kill Blocking Negative SPID in SQL Server

This document provides instructions for killing a blocking negative SPID in SQL Server. It involves running a query on the sys.dm_tran_locks dynamic management view to find the request_owner_guid of the blocking SPID. It then uses the KILL command to terminate the session associated with that GUID value, removing the block.

Uploaded by

mano555
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

How to Kill a Blocking Negative SPID in SQL Server

------------------------------------------

USE Master;

GO

SELECT

DISTINCT(request_owner_guid) as UoW_Guid--,*

FROM sys.dm_tran_locks

WHERE request_session_id =-2

KILL '1E082F52-F7EF-441E-B8C8-58CF7ABA4E51' -- replace GUID value with UoW_Guid value


from above query

Note: Ignore the UoW_Guid with starts with '0000-0000000'

You might also like