Post reply

SQL 2005 Blocking by session id -2

  • June 11, 2010 at 9:16 am

    #140740

    We run Biztalk on SQL Server 2005 cluster. While monitoring servers via Spotlight, I noticed a lot of blocking. The block details showed the main culprit as session id -2. I've never seen a session id with a negative number, so I queried sys.dm_exec_requests and it too showed the blocking session as -2. There isn't a session id of -2 in sys.dm_exec_sessions. Does anyone know if this is a background process or something? I haven't found any info online yet. I'll call MS Support if I can't find an answer.

  • June 11, 2010 at 9:18 am

    #1179261

    Nevermind. I found it in BOL.

    ID of the session that is blocking the request. If this column is 0, the request is not blocked, or information for blocking session is not available or cannot be identified.

    -2 = The blocking resource is owned by an orphaned distributed transaction.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply