We have some blocking going on in our database and when I run sp_who2, in the BlkBy field, I see "-2" for two of the rows. What does this mean? Running SQL Server 2008 R2
SQL Server – Resolving SQL Blocking with SPID of -2
sql server
Related Question
- Sql-server – SSRS Blocking Processes
- SQL Server Blocking SPID – Zero Disk IO and Zero CPU Time Issue
- SQL Server – Resolving Unknown System SPID Blocking User SPIDs
- Sql-server – Guide to protect SQL Server against speculative execution side-channel vulnerabilities
- Sql-server – Blocking caused by Query Store. Unable to clear or disable
- SQL Server – Troubleshooting SPID Suspended ASYNC_NETWORK_IO
- SQL Server – Batch Insert Causing Blocking on Unrelated Tables
- SQL Server Deadlock – Concurrent Update on Primary Key Column
Best Answer
It means you have an open DTC transaction managed by an external ITransaction interface but no Sessions currently using it.
you have to use
KILL UOW
where UOW = UnitOfWork associated with that transaction instead of the session id.---- in text mode run below query