Search This Blog

Monday, 3 September 2012

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)