SPID's are being blocked by -1

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  June 24, 2015 at 10:52 am

  #398643

  I got a situation where all of a sudden SPID are being blocked by a SPID of -1.

  Any ides on how to resolve the process?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  June 24, 2015 at 4:50 pm

  #1807916

  The SPID's with a -1 have about 20 entries for the same DPID.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• JManuelN

  SSCommitted

  Points: 1708

  More actions

  June 25, 2015 at 3:18 am

  #1807972

  SPID -1 is quite odd. It seems an orphaned transaction lock or something similar. Can you try to use the same workaround like SPID -2 issues?

  http://www.mytechmantra.com/LearnSQLServer/Kill-Negative-SPID-in-SQL-Server/[/url]