SQL profiler and performance counter

  • Dear Experts

    I have made a trace file from sql profiler and open it. Also I have created a windows performance counter.

    Now I want to import the performance counter .blg file into te profiler

    BUT the import performance data is disabled in the file menu

    Any idea why it is disabled

    Thanks lot

  • Maybe the trace is still running?

    Greetz
    Query Shepherd

  • no it is a saved file

  • Just out of curiosity. have you included the starttime and endtime columns in the trace.

    If you havent got that then it aint going to work. Its always a good practise to have those columns at the number 1 and 2 poistions. it makes it easier to search records too.

  • I enabled the trace stop time, but still the import performance data is disabled (gray)

    any idea why?

    Thanks

  • zi (2/14/2013)


    I enabled the trace stop time, but still the import performance data is disabled (gray)

    any idea why?

    Thanks

    Not trace stop time, the starttime and endtime event data columns for each trace event. You would have had to define your trace to capture those columns. If you do not have those columns how do you expect Profiler to correlate the perfmon counter log events that were collected at specific times to the events in the trace file?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • How to define start and end times events

    Thanks lot

  • They are Event Data columns, not Events. When you are defining the Trace make sure you capture the StartTime and EndTime columns on all Events you add to the Trace.

    Read this article and when it gets to the part about "the Events Selection tab" you may need to check the "Show all columns" checkbox to see the StartTime and EndTime columns.

    How to: Specify Events for a Trace File (SQL Server Profiler)

    As a side note, you should not be using Profiler to run Traces on production systems. You'll want to start learning how to setup a "Server-side Trace" instead of using Profiler.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • Thank you very much , it works

Viewing 9 posts - 1 through 8 (of 8 total)

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