Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL profiler and performance counter Expand / Collapse
Author
Message
Posted Thursday, February 14, 2013 3:59 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:17 AM
Points: 90, Visits: 239
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
Post #1419941
Posted Thursday, February 14, 2013 6:01 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 31, 2014 10:27 PM
Points: 116, Visits: 347
Maybe the trace is still running?

Greetz
SQL Pizza



sometimes you dont see the pizza for the toppings...
seek and ya shall find...
Post #1420013
Posted Thursday, February 14, 2013 6:15 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:17 AM
Points: 90, Visits: 239
no it is a saved file
Post #1420019
Posted Thursday, February 14, 2013 7:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 7, 2014 9:40 AM
Points: 279, Visits: 91
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.
Post #1420050
Posted Thursday, February 14, 2013 11:28 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:17 AM
Points: 90, Visits: 239


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

any idea why?

Thanks
Post #1420228
Posted Thursday, February 14, 2013 2:34 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 23, 2014 8:34 AM
Points: 7,097, Visits: 12,601
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
Post #1420308
Posted Friday, February 15, 2013 1:40 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:17 AM
Points: 90, Visits: 239


How to define start and end times events

Thanks lot
Post #1420741
Posted Friday, February 15, 2013 1:57 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 23, 2014 8:34 AM
Points: 7,097, Visits: 12,601
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
Post #1420752
Posted Friday, February 15, 2013 2:07 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:17 AM
Points: 90, Visits: 239


Thank you very much , it works
Post #1420761
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse