Sql Server : Difference between spid, kpid and ecid? What is spid? What is kpid? What is ecid?

Posted by Sqltimes
On October 3, 2015
0 Comments

Quick one today: Very often, when dealing with multi-threaded processes and in other cases dealing with deadlocks we run into some interesting artifacts. In this post, we’ll see the meaning of some identifiers (id’s). Specifically spid ecid kpid Spid Every process in Sql Server is carried out under a servers process; Sometimes these are also referred […]