Negative SPID -4

• ps.

  One Orange Chip

  Points: 29423

  More actions

  April 30, 2013 at 8:14 am

  #272008

  Hello All,

  Can someone share some information on -4 SPID? I am aware about -2 and -3 but have never seen -4 and cant find any online resources regarding this. One of our client's server showed blocking by spid -4. They restarted the machine to resolve the issue so I dont have much info. However they had captured sysprocesses details which shows some processes were blocked by -4. I've asked for more details. Apparently they run some linked queries but as per my understanding that would result in -2 spid.

  Pls see attached.

  ---

  
  Pradeep Singh

• manub22

  Hall of Fame

  Points: 3163

  More actions

  June 20, 2016 at 11:24 pm

  #1885949

  I also faced this issue, and following blog post helped a bit in understanding what negative SPIDS are: http://www.mytechmantra.com/LearnSQLServer/Kill-Negative-SPID-in-SQL-Server/[/url]

  ---

  ~manoj | LinkedIn | Facebook | YouTube
  Blog: SQLwithManoj.com