CODEWITHSUNDEEP
sql-serverblocking
Shawn de Wet
Shawn de Wet

Reputation: 5976

SQL Process is being blocked by non-existing PID

I have a SQL Process that is being blocked by a non-existing session_id, as per this screenshot: enter image description here

See the blocking_session_id is -2. But there is no such session in the list of sql sessions!

Any advice as to what is going on here? How do I identify the blocker?

Upvotes: 0

Views: 784

Answers (1)

Ben Thul
Ben Thul

Reputation: 32707

The documentation says that a blocking_session_id of -2 means:

The blocking resource is owned by an orphaned distributed transaction.

Upvotes: 1

Related Questions