SQL to show running requests in SQL Server

slowsql.sql

-- Who is running what at this instant
SELECT dest.text AS [Command text] ,
der.total_elapsed_time as 'total_elapsed_time (ms)',
DB_NAME(der.database_id) AS DatabaseName ,
der.command , des.login_time , des.[host_name] , des.[program_name] , der.session_id
FROM sys.dm_exec_requests der
INNER JOIN sys.dm_exec_connections dec
ON der.session_id = dec.session_id
INNER JOIN sys.dm_exec_sessions des
ON des.session_id = der.session_id
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS dest
WHERE des.is_user_process = 1 and
-- next clause hides this query itself from list of running queries
dest.text not like '-- Who is running what%'
-- if you want to limit the results to only queries for a given DB, uncomment next line
-- and DB_NAME(der.database_id) = 'yourtablename'
ORDER BY [total_elapsed_time (ms)] DESC