SQL Server Performance

2005 Profiler tip....

Discussion in 'SQL Server 2005 General DBA Questions' started by Haywood, Jun 26, 2006.

  1. Haywood New Member

    If you run profiler via sp_trace_create, be aware that you cannot have an INT as the last character of your @TraceFile parameter if the @Options is set for 'file rollover'.

    I have templates built for 2000 that create trace files as \SERVERNAME race_output_06252006.trc 2005 sp_trace_create complained that my file was invalid because it contained a number already when the file rollover option is on.

    I ended up having to rename my output file to \SERVERNAME race_06252006_output.trc and it worked fine.

    Always liked having to deal with these silly little idiosyncracies(sp?). Just figured some other folks may run into this...
  2. Luis Martin Moderator

    Thanks for share.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  3. Haywood New Member

    And it appears that "Duration" is now in microseconds (is milliseconds in 2000)...

    SELECT (Duration / 1000000) AS [Duration in seconds]
    FROM ::fn_trace_gettable ('File.trc',default)

Share This Page