---SQL Server查询正在执行的SQL语句及执行计划

select ds.session_id,dr.start_time,db_name(dr.database_id),dr.blocking_session_id,ds.host_name,

ds.program_name,ds.host_process_id,ds.login_name,dr.status,

dr.command,dr.wait_type,dr.wait_time,dr.open_transaction_count,

dr.percent_complete,dr.estimated_completion_time,dr.row_count,

SUBSTRING(st.text, (dr.statement_start_offset/2)+1,

((CASE dr.statement_end_offset

WHEN -1 THEN DATALENGTH(st.text)

ELSE dr.statement_end_offset

END - dr.statement_start_offset)/2) + 1) AS statement_text,

st.text as full_text,

qp.query_plan

from sys.dm_exec_sessions ds,sys.dm_exec_requests dr--,sys.dm_exec_query_stats qs

CROSS APPLY sys.dm_exec_sql_text(dr.sql_handle) AS st

CROSS APPLY sys.dm_exec_query_plan(dr.plan_handle) as qp

where ds.session_id>50

and dr.session_id<>@@spid

and ds.session_id=dr.session_id

--and dr.sql_handle=qs.sql_handle

and dr.database_id>4