Find the associated stored procedure to query captured in the DMV.

SELECT
	r.session_id
,	r.start_time
,	TotalElapsedTime_ms = r.total_elapsed_time
,	r.[status]
,	r.command
,	DatabaseName = DB_Name(r.database_id)
,	r.wait_type
,	r.last_wait_type
,	r.wait_resource
,	r.cpu_time
,	r.reads
,	r.writes
,	r.logical_reads
,	t.[text] AS [executing batch]
,	SUBSTRING(
				t.[text], r.statement_start_offset / 2, 
				(	CASE WHEN r.statement_end_offset = -1 THEN DATALENGTH (t.[text]) 
						 ELSE r.statement_end_offset 
					END - r.statement_start_offset ) / 2 
			 ) AS [executing statement] 
,	p.query_plan
FROM
	sys.dm_exec_requests r
CROSS APPLY
	sys.dm_exec_sql_text(r.sql_handle) AS t
CROSS APPLY	
	sys.dm_exec_query_plan(r.plan_handle) AS p
ORDER BY 
	r.total_elapsed_time DESC;

Select allOpen in new window

(@P1 varchar(11),@P2 varchar(1))select  distinct o.order_id, o.enddate, lb.value lookback, hb.billinv_id hasbilling   from ordcalc oc   inner join ordcalc pri on (pri.order_id = @P1 )   inner join orders prio on (pri.order_id = prio.order_id)   inner join orders o on (oc.order_id = o.order_id and prio.client_id = o.client_id)   inner join funddept fd on (o.funder_id = fd.funder_id and o.dept_id = fd.dept_id and fd.invformat = 'COMBOSTAT')   inner join funderrefs fr on (o.funder_id = fr.funder_id and fr.name = 'Combine Invoice Code' and fr.textval = isnull(@P2, fr.textval))   outer apply (select XMLData.value('data(/PropBag/Prop[@Name = "Lookback Period"]/@Value)[1]', 'varchar(200)') value   from (   select convert(xml, REFDATA) as XmlData from funderrefs   where NAME = 'Combo Statement Settings'   and funder_id = o.funder_id   ) as t1) as lb   outer apply (select top 1 billinv_id from billinv bi where   o.client_id=bi.client_id and o.order_id=bi.order_id and bi.invoutamt > 0 ) as hb   

Select allOpen in new window