22,206
社区成员
发帖
与我相关
我的任务
分享
SELECT
object_name(st.objectid, st.dbid) as [object name]
,st.[text]
FROM sys.dm_exec_query_stats AS qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st
WHERE datediff(second, creation_time, last_execution_time)>0 AND execution_count > 100
SELECT
object_name(st.objectid, st.dbid) as [object name]
,st.[text]
FROM sys.dm_exec_query_stats AS qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st