查sqlserver进程

select session_id,start_time,[status],[text]
from sys.dm_exec_requests er cross apply sys.dm_exec_sql_text(er.sql_handle)
order by start_time