sqlserver关于session和request表

session这三个参数很重要
select session_id,status,host_name from sys.dm_exec_sessions

request这三个参数很重要

select session_id,status,sql_handle,plan_handle from sys.dm_exec_requests

sql_handle与plan_handle的用法

select * from sys.dm_exec_sql_text(sql_handle)  --sql语句

select *
from
      sys.dm_exec_cached_plans
      cross apply sys.dm_exec_query_plan(plan_handle)
where
      cast(query_plan as nvarchar(max)) like '%Sort%'
      or cast(query_plan as nvarchar(max)) like '%Hash Match%'select * from sys.dm_exec_query_plan(plan_handle)  --执行计划