Frågor som drar mycket kraft

SELECT r.session_id, 
       r.start_time, 
       TotalElapsedTime_ms = r.total_elapsed_time, 
       r.[status], 
       r.command, 
       DatabaseName = Db_name(r.database_id), 
       r.wait_type, 
       r.last_wait_type, 
       r.wait_resource, 
       r.cpu_time, 
       r.reads, 
       r.writes, 
       r.logical_reads, 
       t.[text] AS [executing batch], 
       Substring(t.[text], r.statement_start_offset / 2, 
       ( CASE 
           WHEN r.statement_end_offset = -1 THEN Datalength (t.[text]) 
           ELSE r.statement_end_offset 
         END - r.statement_start_offset ) / 2) AS [executing statement], 
       p.query_plan 
FROM   sys.dm_exec_requests r 
       CROSS apply sys.Dm_exec_sql_text(r.sql_handle) AS t 
       CROSS apply sys.Dm_exec_query_plan(r.plan_handle) AS p 
ORDER  BY r.total_elapsed_time DESC;