select Session_ID = session_id
,Command = command
,Start_Time = start_time
,Status = status
,Percent_Completed = percent_complete
,Time_In_Min = (estimated_completion_time/60000)
,Elapsed_Time_Minutes = (total_elapsed_time/60000)
,Wait_Type = wait_type
,Last_Wait_type = last_wait_type
,Blocking_Session = Blocking_Session_Id
,Reads = reads
,Writes = writes
,Logical_Reads = logical_reads
from sys.dm_exec_requests
where session_id > 50
No comments:
Post a Comment