If I'm wondering what's running, I usually want a little extra information about those queries. Here's a very similiar version with some of the extra information I like to see:

set transaction isolation level read uncommitted

select s.[host_name]

, s.login_name

-- , s.is_user_process

, s.program_name

, r.command

, r.status

, s.session_id

, r.blocking_session_id

-- , r.request_id

, datediff( ms, r.start_time, getDate() ) as age_ms

, r.total_elapsed_time

, r.cpu_time

, r.percent_complete

, r.row_count

, r.granted_query_memory

, r.logical_reads

, txt.[text] as query_text

from sys.dm_exec_requests as r

join sys.dm_exec_sessions as s on (s.session_id=r.session_id)

cross apply sys.dm_exec_sql_text( r.sql_handle ) as txt

where s.is_user_process=1 AND s.session_Id NOT IN (@@SPID)

order by datediff( ms, r.start_time, getDate()) desc