Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sureshot
Yak Posting Veteran
72 Posts |
 Posted - 2006-06-05 : 16:42:21
|
| How would I go about tracing UDF performance in profiler? I'd like to specifically know the impact of the UDF without having to dig into the execution plan of the statement containing it. Is this possible? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-07 : 12:01:54
|
| it should be. make a trace of all instances where sql statement includes the name of udf. |
 |
|
|
sureshot
Yak Posting Veteran
72 Posts |
Posted - 2006-06-07 : 17:23:59
|
| Right but then I have to store and look at the execution plan. I was hoping I could get a nice reading of CPU + Reads for just the UDF part. |
|
|
|
|
|
|
Tracing UDFs?