select text, * from sys.dm_exec_requests cross apply sys.dm_exec_sql_text(sql_handle) select * from sys.dm_exec_sessions where program_name like 'data_engine%' order by total_elapsed_time exec sp_who