Home Forums SQL Server 2008 SQL Server 2008 Administration Automating the SQL Profiler RE: Automating the SQL Profiler

  • June 24, 2013 at 2:59 am

    #1626694

    Running this 24\7 is potentially going to be massive amounts of data. I would have dedicated storage for the trace files.

    exec sp_trace_setevent @TraceID, 'RPC:Completed', 'EndTime', @on

    exec sp_trace_setevent @TraceID, 'RPC:Completed', 'Reads', @on

    exec sp_trace_setevent @TraceID, 'RPC:Completed', 'ClientProcessID', @on

    exec sp_trace_setevent @TraceID, 'RPC:Completed', 'Writes', @on

    exec sp_trace_setevent @TraceID, 'RPC:Completed', 'BinaryData', @on

    exec sp_trace_setevent @TraceID, 'RPC:Completed', 'ApplicationName', @on

    exec sp_trace_setevent @TraceID, 'RPC:Completed', 'CPU', @on

    exec sp_trace_setevent @TraceID, 'RPC:Completed', 'LoginName', @on

    exec sp_trace_setevent @TraceID, 'RPC:Completed', 'SPID', @on

    exec sp_trace_setevent @TraceID, 'RPC:Completed', 'Duration', @on

    exec sp_trace_setevent @TraceID, 'RPC:Completed', 'NTUserName', @on

    exec sp_trace_setevent @TraceID, 'RPC:Completed', 'StartTime', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchCompleted', 'EndTime', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchCompleted', 'Reads', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchCompleted', 'TextData', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchCompleted', 'ClientProcessID', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchCompleted', 'Writes', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchCompleted', 'NTUserName', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchCompleted', 'ApplicationName', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchCompleted', 'StartTime', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchCompleted', 'CPU', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchCompleted', 'LoginName', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchCompleted', 'SPID', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchCompleted', 'Duration', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchStarting', 'TextData', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchStarting', 'ClientProcessID', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchStarting', 'NTUserName', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchStarting', 'ApplicationName', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchStarting', 'StartTime', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchStarting', 'LoginName', @on

    exec sp_trace_setevent @TraceID, 'SQL:BatchStarting', 'SPID', @on

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]