SQL Server Performance

Tuning template returning lots of function calls

Discussion in 'SQL Server 2008 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 fund out what the function is called from this information or what procedure it is in?
    Thanks for the advice
    Kwisatz78, Aug 27, 2009
    #2

  2. Luis Martin Moderator

    You have to understand this: if duration is = 0 then you will trace a lot of sql internal things without meanings.
    Trace something > 0, at least 300 milliseconds.
    Luis Martin, Aug 27, 2009
    #3

  3. Kwisatz78 New Member

    Ok thanks, in the end I found the function to be a simple replace of 0 to null for which gets called a lot of times. I have filtered out this function from my tuning template.
    Kwisatz78, Aug 28, 2009
    #4

Share This Page