[sql]代码库
SELECT TOP 100 db_name(d.[database_id]) AS [数据库名],
s.[NAME] AS [存储名称],
s.[type_desc] AS [存储类型],
d.[cached_time] AS [SP添加到缓存的时间],
d.[last_execution_time] AS [上次执行SP的时间],
d.[last_elapsed_time] AS [上次执行SP所用的时间（微秒）],
d.[total_elapsed_time] AS [完成此SP的执行所用的总时间（微秒）],
d.[total_elapsed_time] / d.[execution_count] AS [平均执行时间（微秒）],
d.[execution_count] AS [自上次编译以来所执行的次数]
FROM SYS.[procedures] S
JOIN SYS.[dm_exec_procedure_stats] D ON S.[object_id] = D.[object_id]
WHERE S.NAME='SP_Name'
ORDER BY D.total_elapsed_time / D.execution_count DESC
会python真的可以为所欲为0(回)
9天前
这里还有人吗1(回)
194天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
419天前
鸽子
0(回)
503天前
by: 发表于：2017-09-08 09:55:06 顶(0) | 踩(0) 回复
？？
回复评论