At the server level, if you do not know which db to trace, try

Using perf mon is also a good idea if you are on W2K server and you can...

i am trying to optimize by saving on joins.  yes, I am creating several views, and i know I cannot execute sql_executesql inside an UDF.  I was wondering if there...