(session ID -2 is not valid) Dealing with Negative Session ids in Sql Server
SQL server being a complex mechanism of handling processes throughout their life cycle often gives out interesting anomalies, One such was encountered today on one of my production servers, there was a huge blocking on chain of processes and at the root of this chain was a session with the weirdest session id The session id literally was " -2 " , it is hard to make sense out of it as SQL server always works with positive spids. Research on this is itself a tedious job. After the R&D phase it was somewhat easier to diagnose the problem. The root cause refers to a phase of distributed transaction, A distributed transaction is referred when a process is extended over more than one servers i.e Process A of server 1 needs data to be manipulated on Server 2, so SQL server uses MSDTC (linked server) service to carry this process from one server to another. Going back to our issue, now According to msdn and other online resources, the session id -2 means that ...