TSQLScripts.com: Script Details

TSQLScripts.com.

skip to the main content area of this page

Transact SQL scripts written by
DBAs and Developers for
DBAs and Developers.

To submit a comment about this script click here here or to submit your own script click here.

What SQL Queries Are Currently Running?
Description:
Taken from: http://blogs.msdn.com/irenak/archive/2007/04/27/sysk-338-what-sql-queries-are-currently-running.aspx This is cool script - wish I had written it!
Submitted By: jond

select		session_id, 
			request_id, 
			start_time, 
			status, 
			cpu_time, 
			er.total_elapsed_time,
			substring( st.text, 
				(er.statement_start_offset/2) + 1, 
				((	case er.statement_end_offset 
						when -1 then datalength(st.text) 
						else er.statement_end_offset 
					end - er.statement_start_offset)/2) + 1) as query   
from		sys.dm_exec_requests er
cross apply	sys.dm_exec_sql_text(er.sql_handle) st

Date: 08/21/2007

Submitted By

Comment

MattM

This query works great when trying to figure out what sql statement is executing when running in a stored procedure.

Date: 05/11/2007

Submitted By

Comment

2008DBA

Nice, this will helpful when trying to find problem queries.