What is the difference between spid, kpid and ecid in sysprocesses?
When I received the question, I went to the SQLAuthority.com website and looked at it, but the reality was that I had not written about it before.Here it goes.
Let's understand where we can find three columns.There are three columns in the table.The following script shows that.
The server process is running every process in the database.Session IDs are what they are referred to as.Each of the session processes has a unique ID.
There is a context for Kpid SPIDs.The operating system has the same processes.The Kernal Process has its own ID.
All sub-threads have the same parent server process ID.Each sub-thread has a unique ECID.
What about kpid for user processes?How can I replace the kpid value for all connected users?
Pinal Dave is an independent consultant with 17 years of hands-on experience.He has a Masters of Science degree.
Pinal has written 12 books and 37 courses.Pinal has written thousands of database tech articles on his website to help others build their expertise.
Pinal has a deep commitment to flawless customer service.If you need help with any performance tuning issues, please reach out to pinal@sqlauthority.com.
Nupur Dave is an independent consultant.She works with clients to build long and short term campaigns to drive leads for their sales.
Do you want to speed up your server without sharing it's credentials?We can resolve your biggest performance troublemakers in less than four hours with my Comprehensive Database Performance Health Check.