Status=SUSPENDED

• Michael Herfkens

  SSC Rookie

  Points: 41

  More actions

  July 29, 2008 at 10:21 pm

  #123642

  When I run an sp_who2 I see processes with the status marked as SUSPENDED. How can I measure or track those? I want to be able to count them over time. Can anyone give me some hints on writing a T-SQL script to keep track of these? Thanks

  Michael

• Animal Magic

  SSChampion

  Points: 13964

  More actions

  July 30, 2008 at 2:49 am

  #850302

  what do you want to do with them? the easiest way would be to output sp_who2 into a temp table and then work on it from there.