Try this:

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'