复制SELECT TOP 10 a.object_id,通过 a.database_id, OBJECT_NAME(object_id, database_id) proc name,   a.cached_time, a.last_execution_time, a.total_elapsed_time, a.total_elapsed_time/a.execution_count AS [avg_elapsed_time],   a.execution_count,   a.total_physical_reads/a.execution_count avg_physical_reads,   a.total_logical_writes,   a.total_logical_writes/ a.execution_count  avg_logical_reads,   a.last_elapsed_time,   a.total_elapsed_time / a.execution_count   avg_elapsed_time,   b.text,c.query_plan   FROM sys.dm_exec_procedure_stats AS a   CROSS APPLY sys.dm_exec_sql_text(a.sql_handle)  b   CROSS APPLY sys.dm_exec_query_plan(a.plan_handle) c   ORDER BY [total_worker_time] DESC;   GO  1.2.3.4.5.6.7.8.9.10.11.12.13.14.