﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration  / SQL profiler and performance counter / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Sun, 19 May 2013 02:15:09 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: SQL profiler and performance counter</title><link>http://www.sqlservercentral.com/Forums/Topic1419941-1550-1.aspx</link><description>  Thank you very much , it works</description><pubDate>Fri, 15 Feb 2013 14:07:53 GMT</pubDate><dc:creator>zi</dc:creator></item><item><title>RE: SQL profiler and performance counter</title><link>http://www.sqlservercentral.com/Forums/Topic1419941-1550-1.aspx</link><description>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 [i]Events Selection[/i] tab" you may need to check the "Show all columns" checkbox to see the StartTime and EndTime columns.[u][url=http://msdn.microsoft.com/en-us/library/ms188674(v=sql.105).aspx]How to: Specify Events for a Trace File (SQL Server Profiler)[/url][/u]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.</description><pubDate>Fri, 15 Feb 2013 13:57:18 GMT</pubDate><dc:creator>opc.three</dc:creator></item><item><title>RE: SQL profiler and performance counter</title><link>http://www.sqlservercentral.com/Forums/Topic1419941-1550-1.aspx</link><description>  How to define start and end times eventsThanks lot</description><pubDate>Fri, 15 Feb 2013 13:40:04 GMT</pubDate><dc:creator>zi</dc:creator></item><item><title>RE: SQL profiler and performance counter</title><link>http://www.sqlservercentral.com/Forums/Topic1419941-1550-1.aspx</link><description>[quote][b]zi (2/14/2013)[/b][hr]   I enabled the trace stop time, but still the import performance data is disabled (gray)any idea why?Thanks[/quote]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?</description><pubDate>Thu, 14 Feb 2013 14:34:11 GMT</pubDate><dc:creator>opc.three</dc:creator></item><item><title>RE: SQL profiler and performance counter</title><link>http://www.sqlservercentral.com/Forums/Topic1419941-1550-1.aspx</link><description>   I enabled the trace stop time, but still the import performance data is disabled (gray)any idea why?Thanks</description><pubDate>Thu, 14 Feb 2013 11:28:40 GMT</pubDate><dc:creator>zi</dc:creator></item><item><title>RE: SQL profiler and performance counter</title><link>http://www.sqlservercentral.com/Forums/Topic1419941-1550-1.aspx</link><description>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.</description><pubDate>Thu, 14 Feb 2013 07:16:17 GMT</pubDate><dc:creator>Makarand Mohandas</dc:creator></item><item><title>RE: SQL profiler and performance counter</title><link>http://www.sqlservercentral.com/Forums/Topic1419941-1550-1.aspx</link><description>no it is a saved file</description><pubDate>Thu, 14 Feb 2013 06:15:59 GMT</pubDate><dc:creator>zi</dc:creator></item><item><title>RE: SQL profiler and performance counter</title><link>http://www.sqlservercentral.com/Forums/Topic1419941-1550-1.aspx</link><description>Maybe the trace is still running?</description><pubDate>Thu, 14 Feb 2013 06:01:08 GMT</pubDate><dc:creator>SQL Pizza</dc:creator></item><item><title>SQL profiler and performance counter</title><link>http://www.sqlservercentral.com/Forums/Topic1419941-1550-1.aspx</link><description>Dear ExpertsI 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 menuAny idea why it is disabledThanks lot</description><pubDate>Thu, 14 Feb 2013 03:59:04 GMT</pubDate><dc:creator>zi</dc:creator></item></channel></rss>