Post reply

Negative SPID -4

  • 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

  • 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

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

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