sqlserver 查看最耗时的前10个存储过程

概述  SELECT TOP 10 OBJECT_NAME(a.object_id,database_id) SP_Name, DB_NAME(a.database_id) Database_Name, a.cached_time, a.last_execution_time, a.total_elapsed_time, a.total_elapsed_time/a.execution_count

 

SELECT top 10 OBJECT_name(a.object_ID,database_ID) SP_name,DB_name(a.database_ID) Database_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;

总结

以上是内存溢出为你收集整理的sqlserver 查看最耗时的前10个存储过程全部内容，希望文章能够帮你解决sqlserver 查看最耗时的前10个存储过程所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。