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