February 14, 2013 at 3:59 am
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
February 14, 2013 at 6:01 am
Maybe the trace is still running?
Greetz
Query Shepherd
February 14, 2013 at 6:15 am
no it is a saved file
February 14, 2013 at 7:16 am
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.
February 14, 2013 at 11:28 am
I enabled the trace stop time, but still the import performance data is disabled (gray)
any idea why?
Thanks
February 14, 2013 at 2:34 pm
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
February 15, 2013 at 1:40 pm
How to define start and end times events
Thanks lot
February 15, 2013 at 1:57 pm
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
February 15, 2013 at 2:07 pm
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