SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
	SELECT 	
	 req.command type
	,(select top 1 net_transport from sys.dm_exec_connections con with(nolock) where req.session_id=con.session_id) transport
	,(select top 1 protocol_type from sys.dm_exec_connections con with(nolock) where req.session_id=con.session_id) protocol_type	
	, case when sqltext.text like 'FETCH%' then curtext.text else sqltext.text end as command_text			
	, SUBSTRING(sqltext.text, (req.statement_start_offset/2)+1, 
        ((CASE req.statement_end_offset
          WHEN -1 THEN DATALENGTH(sqltext.text)
         ELSE req.statement_end_offset
         END - req.statement_start_offset)/2) + 1) AS statement_text
    ,req.percent_complete
	,db_name(req.database_id) db_name
	,req.session_id as s_id
	,req.blocking_session_id as bls_id
	,req.status as req_status
	,req.cpu_time req_cpu_time_ms
	,ses.cpu_time ses_cpu_time_ms
	,cast(case when req.start_time<DATEADD(ms,-2147483647, GETDATE()) then NULL else  datediff(ms,req.start_time, getdate()) / 1000.0 end as decimal(14,4)) elapsed_sec	
	,ses.original_login_name
	,ses.host_name
	,ses.program_name
	,ses.host_process_id
	,ses.client_interface_name
	,ses.memory_usage
	,ses.reads
	,ses.writes
	,ses.logical_reads
	,ses.row_count		
	,p.query_plan
	FROM 
		        sys.dm_exec_requests req with(nolock)	
	INNER JOIN  sys.dm_exec_sessions ses with(nolock) on req.session_id=ses.session_id
	OUTER APPLY sys.dm_exec_cursors(req.session_id) cur 
	OUTER APPLY sys.dm_exec_sql_text(cur.sql_handle)  AS curtext 	 
	CROSS APPLY sys.dm_exec_sql_text(req.sql_handle)  AS sqltext 	
	OUTER APPLY	sys.dm_exec_query_plan(req.plan_handle) AS p 	
	where 1=1    
	and req.session_id <> @@SPID
	order by 
	elapsed_sec desc