SELECT d.name			database_name,
		   r.start_time,
		   r.[status],
		   r.transaction_id,
		   r.session_id,
		   blocking_session_id,	   
		   sq.[text],
		   r.sql_handle,
		   o.name   [object_name],
		   case 
				when r.transaction_isolation_level = 0 THEN 'не указан'
				when r.transaction_isolation_level = 1 THEN 'читать незафиксированные'
				when r.transaction_isolation_level = 2 THEN 'читать зафиксированные'
				when r.transaction_isolation_level = 3 THEN 'повторяемые результаты'
				when r.transaction_isolation_level = 4 THEN 'сериализуемые'
				when r.transaction_isolation_level = 5 THEN 'моментальный снимок'
		   END   isolation_lvl,
		   r.total_elapsed_time/1000 as [total_elapsed_time, sec],  
		   r.wait_time/1000 as [wait_time, sec], 
		  (r.total_elapsed_time - r.wait_time)/1000 as [work_time, sec] ,
		  ss.login_name,
		  CASE   
			 WHEN r.[statement_start_offset] > 0 THEN  
				--The start of the active command is not at the beginning of the full command text 
				CASE r.[statement_end_offset]  
				   WHEN -1 THEN  
					  --The end of the full command is also the end of the active statement 
					  SUBSTRING(sq.TEXT, (r.[statement_start_offset]/2) + 1, 2147483647) 
				   ELSE   
					  --The end of the active statement is not at the end of the full command 
					  SUBSTRING(sq.TEXT, (r.[statement_start_offset]/2) + 1, (r.[statement_end_offset] - r.[statement_start_offset])/2)   
				END  
			 ELSE  
				--1st part of full command is running 
				CASE r.[statement_end_offset]  
				   WHEN -1 THEN  
					  --The end of the full command is also the end of the active statement 
					  RTRIM(LTRIM(sq.[text]))  
				   ELSE  
					  --The end of the active statement is not at the end of the full command 
					  LEFT(sq.TEXT, (r.[statement_end_offset]/2) +1)  
				END  
			END AS [executing statement]  
    FROM sys.dm_exec_requests  r
		cross APPLY sys.dm_exec_sql_text(r.sql_handle) sq
		inner join sys.databases AS d ON  r.database_id = d.database_id
		LEFT JOIN sys.objects AS o ON sq.objectid = o.[object_id]
		left join sys.dm_exec_sessions ss on r.session_id = ss.session_id
    ORDER BY r.total_elapsed_time desc