Md.Mofizur Rahman Sohel's Blog

SELECT  sqltext. TEXT , req.session_id , req.status , req.command , req.cpu_time , req.total_elapsed_time FROM  sys.dm_exec_requests req CROSS  APPLY sys.dm_exec_sql_text ( sql_handle )  AS  sqltext