用于查找 UDF 上次执行时间的 TSQL 查询

2021-09-10 00:00:00 tsql sql-server

我知道确定存储过程上次执行时间的方法，但是否有类似的方法可用于确定用户定义函数的执行时间?

I know of ways to determine the last execution time of a stored procedure, but are there similar methods available to determine the execution time of a user defined function?

推荐答案

如果详细信息仍在缓存中...

If details are still in the cache...

SELECT qs.last_execution_time
FROM   sys.dm_exec_query_stats qs
       CROSS APPLY (SELECT 1 AS X
                    FROM   sys.dm_exec_plan_attributes(qs.plan_handle)
                    WHERE  ( attribute = 'objectid' 
                             AND value = OBJECT_ID('[YourDBName].[dbo].[YourFunctionName]') )
                            OR ( attribute = 'dbid' 
                                 AND value = DB_ID('YourDBName') )
                    HAVING COUNT(*) = 2) CA

相关文章