Post reply

Why are almost all of my kpid values zero

  • April 10, 2008 at 10:02 pm

    #120864

    Should every spid have a corresponding non zero kpid value? Why is it that when i do a select from sysprocesses most of the values I see for kpid are zero?

  • April 11, 2008 at 12:03 am

    #801291

    System processes (spid < 51) or user processes?

    Are you running SQL with the windows fibres enabled?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 11, 2008 at 10:19 am

    #801618

    Both.

    I am not using fibers.

    I just did a select from sysprocesses and only 1 record out of 92 had a non zero kpid value.

    I can find a kpid value with perfmon but am unable to associate it with a spid in sysprocesses.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply