Need Help Finding a Replacement for sys.sysprocesses
Unfortunately, Microsoft is aware of the lack of replacements. You can upvote &amp; watch these Connect items for more details:

Deprecation of sysprocesses - DMV's doesn't fully replace all columns - by Tony Rogerson SQL

There is no real alternative to master.dbo.sysprocesses - by GV1973