Using dm_exec_function_stats in SQL Server 2016

Using dm_exec_function_stats in SQL Server 2016

You can use the dm_exec_function_stats (in SQL Server 2016) to check detailed execution details of a function. These include:

execution_count - the number of times this function has been executedlast_execution_time - how long did the function take to execute

Here is a nice example of using dm_exec_function_stats

SELECTDB_NAME(database_id) AS DBName,OBJECT_SCHEMA_NAME(OBJECT_ID, database_id) + '.' + OBJECT_NAME(OBJECT_ID, database_id) AS FName,STATS.execution_count,STATS.total_elapsed_time / STATS.execution_count AS ElapsedTime,STATS.last_execution_time,STATS.max_worker_time,STATS.max_physical_reads,STATS.max_logical_reads,STATS.max_logical_writes,TEXT.TextFROM sys.dm_exec_function_stats STATSCROSS APPLY sys.dm_exec_sql_text(sql_handle) TEXT

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist