var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL SERVER 2000 - Table SYSPROCESSES
Despiste what it is mentioned in B.O.L., in the Table SYSPROCESSES, the column KPID has almost always the value 0 !!!
If anyone knows how I can find the right link between a SPID and the corresponding KPID, I shoud be very happy to know to.
It concerns SQL SERVER 2000 under WINDOWS 2000 SP3.
Thanks in advance for any help about that ...
Kpid is the kernel-process ID. Under SQL Server for Windows NT this is the thread ID number, also known as "ID thread," and is assigned by Windows NT when the thread is created.
Kpid is visible by querying the kpid column of master..sysprocesses. It is only filled in for spid numbers four and higher.
Take help of PERFMON for accurate counters.