I am trying to browse online but can not get enough info on how to measure performance of scalar UDF's in SQL server 2014.
Newer version yes i do see from plans we can get the same and newer dmv's
But i have on my SQL 2014 where bunch of scalar uDF's exist including the one which includes function involving calculation and functions calling base or user tables as well.
I am seeing blocking and SP performance and seems few calls using those scalar functions. But could not find a way to prove how bad those functions might be when calling from so many effected SP's
sql_statement_completedshould allow you to aggregate
durationetc. And re-writing a similar query to use an inline table-valued function you should be able to prove by just running them and seeing the performance difference. There is no better proof than that.