kpid all 0

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Hassan (fatima_ja_at_hotmail.com)
Date: 07/17/04


Date: Fri, 16 Jul 2004 17:28:33 -0700

I have looked at this following article

http://www.sql-server-performance.com/performance_monitor_tips.asp

and there is a mention on how to relate the thread id to kpid in
sysprocesses but all the kpids are 0 when i query it.

I am using SQL 2000...

What is this kpid and how do i get it to reflect whats in the article above?

Thanks