Michael Herfkens
SSC Rookie
Points: 31
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
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply