SQL Profiler "Server processes SQL server trace data" option info

5 Sep 2006 4:39 AM

Prasad

Hi,
    Wanted to know what this option means in SQL Profiler, "Server processes
SQL server trace data", read that SQL Server will not miss the events but
the SQL Server will be loaded, but wanted to know how this option can be set
using "sp_trace_create" stored procedure.
    Created two traces using profiler UI and scripted them and found that
the options value was "0" when the above option was not selected and was "2"
when the same was selected. According to BOL when options value is "2" it
means "Trace File Rollover".
    Is the option in the UI same as "Trace File Rollover" ?

    TIA

Thanks
P

5 Sep 2006 5:34 AM

Kalen Delaney

No, trace file rollover is enabled when you check the box for 'enable file
rollover'. You must have checked it for one of the traces and not for the
other.

When you start a trace using server side procedures, the only possibility is
that the server will process all the data as there is no SQL Server Profiler
GUI to process it. Thus, the option "Server processes SQL server trace data"
is moot.

--
HTH
Kalen Delaney, SQL Server MVP

Show quote

"Prasad" <ekke_nik***@yahoo.co.uk> wrote in message
news:OIgPjVK0GHA.4932@TK2MSFTNGP02.phx.gbl...
> Hi,
>    Wanted to know what this option means in SQL Profiler, "Server
> processes SQL server trace data", read that SQL Server will not miss the
> events but the SQL Server will be loaded, but wanted to know how this
> option can be set using "sp_trace_create" stored procedure.
>    Created two traces using profiler UI and scripted them and found that
> the options value was "0" when the above option was not selected and was
> "2" when the same was selected. According to BOL when options value is "2"
> it means "Trace File Rollover".
>    Is the option in the UI same as "Trace File Rollover" ?
>
>    TIA
>
> Thanks
> P
>
>