How to view running queries in Sql Server

To see which queries are currently executing on a server, you can use this query:
SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time /1000 as 'Elapsed time, seconds',
req.total_elapsed_time /1000 / 60 as 'Elapsed time, minutes'
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext;


Query can be killed using this command:
kill session_id

Something tells me it's not a great idea to use it, though.. need to read more on it.


Taken from Sql Authority site