---sql text 和执行计划select top 200 c.creation_time ,c.last_execution_time ,c.execution_count, --c.query_text,plan1.query_plan , c.total_worker_time/execution_count/1000/1000.00 AGV_worker_time_S,c.total_elapsed_time/execution_count/1000/1000.00 AGV_elapsed_time_S from (SELECT ( SELECT SUBSTRING(text, statement_start_offset/2 + 1, (CASE WHEN statement_end_offset = -1 THEN LEN(CONVERT(nvarchar(max), text)) * 2 ELSE statement_end_offset END - statement_start_offset)/2)FROM sys.dm_exec_sql_text(sql_handle)) AS query_text,dqs.*FROM sys.dm_exec_query_stats dqs) cCROSS APPLY sys.dm_exec_query_plan(c.plan_handle) plan1 where lower(c.query_text) like '%table%' --and lower(c.query_text) like '%table_column%' --索引的第一个列order by c.total_elapsed_time/execution_count desc -- 按照执行时间排序---索引的使用时间select i.name,diu. * from sys.dm_db_index_usage_stats diu left join sys.indexes i
on diu.index_id=i.index_id
where diu.object_id=OBJECT_ID('dbo.table')and i.object_id=OBJECT_ID('dbo.table')
把第一个执行结果导出为txt文本后，有execl程序打开，筛选列为query_plan 的执行计划，用 index name 筛选，有用的话会显示
