SQL Server Performance

Server Side Trace Problem

Discussion in 'SQL Server Reporting Services' started by Jpac, Mar 16, 2007.

  1. Jpac New Member

    i am tracing my sql 200 server with these events being captured:<br /><br />@events = 10,25,33,42,43,46,47,55,104,105,108,109,110,111,113,114,118<br />@columns = 1,3,6,8,9,10,11,12,13,14,15,35 <br /><br /><br />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.<br /><br />any help would be greatly appreciated.
  2. Jpac New Member

    anyone have an answer?

Share This Page