As suggested only PROFILER will come into rescue, but don't forget to use server side trace if the server is already stressed with performance in this case. As I have suggested if you have found such SPID with SP_who2 then running fn_get_sql will give you more information. Fyi see this BlogPost too...