SELECT r.*,t.text FROM sys.dm_exec_requests r cross apply sys.dm_exec_sql_text(r.sql_handle) t
WHERE r.status IN (N'Suspended',N'Running',N'Runnable',N'Pending')
The text column is the code of the procedure/batch that is currently running in SQL Server
If all your SPs finish every quickly, the query may not be able to catch anything.
You can try the following in a separate window then run the above query, you will catch it
select * from master.dbo.spt_values
WAITFOR DELAY N'00:30:00'