Friday, February 24, 2012

capture udf calls in trace

I know is possible I just forgot how. Thanks.
SP:Completed will fire once for every execution of a UDF. If you have a
query that processes 10K rows with a UDF you will get 10K events so use it
wisely.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
<a> wrote in message news:u7Qzny1kIHA.3780@.TK2MSFTNGP06.phx.gbl...
>I know is possible I just forgot how. Thanks.
>
|||Thank you.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OwmCE81kIHA.4684@.TK2MSFTNGP06.phx.gbl...
> SP:Completed will fire once for every execution of a UDF. If you have a
> query that processes 10K rows with a UDF you will get 10K events so use
> it wisely.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> <a> wrote in message news:u7Qzny1kIHA.3780@.TK2MSFTNGP06.phx.gbl...
>

No comments:

Post a Comment