trace

SELECT sqltext.TEXT
,req.session_id
,req.status
,req.command
,req.cpu_time
,req.total_elapsed_time
,start_time
,right(convert(varchar,dateadd(ms, datediff(ms, start_time, getdate()), ‘1900-01-01’),121), 12) as ‘batch_duration1’
,wait_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext