SQL Server Performance

Lots of Function calls in tuning template

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by Kwisatz78, Aug 27, 2009.

  1. Kwisatz78 New Member

    Hi there - I recently ran a trace to be used by the DTA. The file grew incredibly quickly and in the trace I can see masses of the following all with a duration of 0
    Object Type = 20038 - FN
    These are all stmtcompleted events. How can I tell what is causing this? I assume this is some function call in a procedure somewhere, but how can I find out where the function is being called from or what procedure it is in?
    Also should I filter out this function call to reduce the size of my trace file?
    Thanks for the advice
  2. satya Moderator

  3. Kwisatz78 New Member

    HI thanks - I found this to be a function thats replacing 0 with null and have filtered it from my tuning template.

Share This Page