check master..sysprocesses table , you can filter based on your criteria based on session status /cputime /diskIO / OpenTarn....
is that what u r looking for?
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA