SELECT TOP 3 SUBSTRING(text,
   (statement_start_offset/2) + 1,
    ((CASE statement_end_offset
          WHEN -1
              THEN DATALENGTH(text)
          ELSE statement_end_offset
      END - statement_start_offset)/2) + 1)
         AS query_text, *
FROM sys.dm_exec_requests
    CROSS APPLY sys.dm_exec_sql_text(sql_handle)
    CROSS APPLY
       sys.dm_exec_text_query_plan
         (plan_handle,statement_start_offset,
          statement_end_offset)
ORDER BY total_elapsed_time DESC