问题描述
我知道确定存储过程上次执行时间的方法,但是否有类似的方法可用于确定用户定义函数的执行时间?
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