Jeff Moden (3/13/2014)
GilaMonster (3/13/2014)
Jeff Moden (3/12/2014)
Using "Statistics TIME, IO" will also be way off if there are any non iTVF functions in the mix.IO will be. Time, if you look at the final one for the entire batch, is correct.
I guess it depends on your definition of "correct".
Correct in the sense that it isn't way too low, like stats IO is (where the reads done by the UDF aren't displayed), but yeah, observer effect can hit pretty badly with them, probably because of the massive number of batches which get run and must be tracked.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability