<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 Administration
»
SQL profiler and performance counter
SQL profiler and performance counter
Rate Topic
Display Mode
Topic Options
Author
Message
zi
zi
Posted Thursday, February 14, 2013 3:59 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, April 26, 2013 11:23 AM
Points: 76,
Visits: 188
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
SQL Pizza
SQL Pizza
Posted Thursday, February 14, 2013 6:01 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116,
Visits: 293
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
zi
zi
Posted Thursday, February 14, 2013 6:15 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, April 26, 2013 11:23 AM
Points: 76,
Visits: 188
no it is a saved file
Post #1420019
Makarand Mohandas
Makarand Mohandas
Posted Thursday, February 14, 2013 7:16 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, March 04, 2013 5:34 AM
Points: 279,
Visits: 88
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
zi
zi
Posted Thursday, February 14, 2013 11:28 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, April 26, 2013 11:23 AM
Points: 76,
Visits: 188
I enabled the trace stop time, but still the import performance data is disabled (gray)
any idea why?
Thanks
Post #1420228
opc.three
opc.three
Posted Thursday, February 14, 2013 2:34 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 6:57 PM
Points: 6,724,
Visits: 11,771
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
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1420308
zi
zi
Posted Friday, February 15, 2013 1:40 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, April 26, 2013 11:23 AM
Points: 76,
Visits: 188
How to define start and end times events
Thanks lot
Post #1420741
opc.three
opc.three
Posted Friday, February 15, 2013 1:57 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 6:57 PM
Points: 6,724,
Visits: 11,771
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
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1420752
zi
zi
Posted Friday, February 15, 2013 2:07 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, April 26, 2013 11:23 AM
Points: 76,
Visits: 188
Thank you very much , it works
Post #1420761
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
