SQL Server Performance Forum – Threads Archive

Server Side Trace Problem

i am tracing my sql 200 server with these events being captured: @events = 10,25,33,42,43,46,47,55,104,105,108,109,110,111,113,114,118 @columns = 1,3,6,8,9,10,11,12,13,14,15,35 The problem is it is capturing all events executed within all SP’s. I want to capture when a SP is started and completed, but i dont want to capture every select, insert, delete within the started SP. Capturing these events within the SP are creating my trace files to grow too much. and frankly i dont want to trace the executions within the SP. But you think the event for capturing the contents of the SP would be event # 44 and 45 SP<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />tmtStarting and SP<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />tmtCompleted but as you can see by the events i listed i am not using these events. Just wondering if anyone knew off hand which event i can omit without having to remove one by one and test. any help would be greatly appreciated.

anyone have an answer?

]]>