SQL show running queries

SQL show running queries

We sometimes need to find out running queries on sql server box. To show running queries using t-sql I use the syntax below

SELECT *
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle)