Answered by:
MSSQL 2008: Where is the KPID?

Question
-
Hi Guys,
Can someone advise where I can find the KPID from sysprocesses in the equivalent dm%'s (can't find it in sessions, connections or requests)? I realise this is still available within (the compatability view) sysprocesses but would rather source it from the (new) correct location.
Is KPID still available?
Thanks, Rob
Answers
-
Check out the following DMV:
select * from sys.dm_os_threads
Let us know if helpful.
Kalman Toth, SQL Server & Business Intelligence Training; SQLUSA.com- Marked as answer by Robert Varga Tuesday, April 27, 2010 9:59 AM
All replies
-
-
-
Check out the following DMV:
select * from sys.dm_os_threads
Let us know if helpful.
Kalman Toth, SQL Server & Business Intelligence Training; SQLUSA.com- Marked as answer by Robert Varga Tuesday, April 27, 2010 9:59 AM
-
One of the two can help select * from sys.sysprocesses sp_who
- Proposed as answer by Muhammad Abbas Tuesday, April 27, 2010 9:57 AM
- Unproposed as answer by Robert Varga Tuesday, April 27, 2010 10:00 AM
-
-
-