SQL Server 2016: Script to get information of Cached Functions (Total Execution Time)

SQL Server 2016 introduced one new DMV is sys.dm_exec_function_stats which returns the aggregate performance statistics for cached functions. It is very similar to sys.dm_exec_query_stats and it returns information about scalar functions, In-Memory functions and CLR functions. You can also get the number of execution count of functions which helps you to troubleshoot performance related problems. […]

January 6, 2018 SQL Server, SQL Server DBA Script