SQL Server – Find Currently Running Queries

http://blog.sqlauthority.com/2009/01/07/sql-server-find-currently-running-query-t-sql/

A customize version from Pinal Dave blog, few more helpful columns added:

• database name
• host name
• program name and
• login name

SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time,
DB_NAME(req.database_id) AS database_name,
ses.host_name, 
ses.program_name, 
ses.login_name
FROM sys.dm_exec_requests req
INNER JOIN sys.dm_exec_sessions ses ON ses.session_id = req.session_id
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext