Thread

• shahgols

  SSCrazy Eights

  Points: 9874

  More actions

  November 21, 2002 at 3:29 pm

  #58688

  Is it possible to see which process has which thread(s)? Thanks.

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  November 22, 2002 at 12:47 am

  #442063

  I haven't used this tool but hope it helps.

  http://www.sysinternals.com/ntw2k/freeware/pmon.shtml

• Antares686

  SSC Guru

  Points: 125444

  More actions

  November 22, 2002 at 4:19 am

  #442071

  This will show you what SPID is running under what thread then you can look at the tool below for stats on that thread.

  DBCC SQLPERF(THREADS)