Post reply

problem with saved trace files in sql profiler

  • March 28, 2008 at 1:31 pm

    #185676

    hi,

    I run a trace n saved it to a file. I run for 2 hrs, I got like 52 trace files each of 5mb.

    like trace,trace1,trace2.....trace 52. My question is how to analyze these all files,could I need to analyze individual trace files or there is any other way to all files together.

    could you plz help me out from this confusion?

    Thanks

  • March 28, 2008 at 2:05 pm

    #795475

    Here are two ways you can work with the rollover files.

    Open SQL Profiler and select File/Open/Trace File, select the first file in the rollover set. Once that loads you'll be prompted, albeit 52 times.

    Or, use the fn_trace_gettable function. Either query directly from the function or load the results into a table.

    SELECT * FROM ::fn_trace_gettable('c:\mytraces\trace1.trc', default)

  • March 29, 2008 at 10:30 am

    #795604

    I usually make sure I set the rollover to around 250mb - 1gb depending upon activity. The easiest is probably to load into a table although you'll need a lookup for the events which are changed to int values.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply