Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    South of France

    Unanswered: SQL SERVER 2000 - Table SYSPROCESSES

    Hello friends,

    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 ...

  2. #2
    Join Date
    Aug 2002
    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.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts