SQLServerCentral.com / Administering / SQL Server 2005 / Interpret Output of TSQL_Replay trace / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 09:09:13 GMT20RE: Interpret Output of TSQL_Replay tracehttp://www.sqlservercentral.com/Forums/Topic1492989-146-1.aspxIncase if someone else is looking for an answer hopefully this might help. Jonathan Kehayias explained me in detail, below is the script from our email conversation.There is a ProfilerSpecialEvents.XML.profiler file that defines these events, it is located in the C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Profiler\TraceDefinitions on my 2012 instance. From the XML: &lt;COLUMNLIST&gt; &lt;COLUMN&gt; &lt;ID&gt;65521&lt;/ID&gt; &lt;TYPE&gt;1&lt;/TYPE&gt; &lt;NAME&gt;SourceRow&lt;/NAME&gt; &lt;DESCRIPTION&gt;The original row number for the event executed&lt;/DESCRIPTION&gt; &lt;FILTERABLE&gt;true&lt;/FILTERABLE&gt; &lt;REPEATABLE&gt;false&lt;/REPEATABLE&gt; &lt;REPEATEDBASE&gt;false&lt;/REPEATEDBASE&gt; &lt;/COLUMN&gt; &lt;COLUMN&gt; &lt;ID&gt;65520&lt;/ID&gt; &lt;TYPE&gt;1&lt;/TYPE&gt; &lt;NAME&gt;ExecutionTime&lt;/NAME&gt; &lt;DESCRIPTION&gt;Time taken for query execution excluding result fetching&lt;/DESCRIPTION&gt; &lt;FILTERABLE&gt;true&lt;/FILTERABLE&gt; &lt;REPEATABLE&gt;false&lt;/REPEATABLE&gt; &lt;REPEATEDBASE&gt;false&lt;/REPEATEDBASE&gt; &lt;/COLUMN&gt; &lt;COLUMN&gt; &lt;ID&gt;65519&lt;/ID&gt; &lt;TYPE&gt;1&lt;/TYPE&gt; &lt;NAME&gt;ExecutionAndFetchTime&lt;/NAME&gt; &lt;DESCRIPTION&gt;Time taken for query execution including result fetching&lt;/DESCRIPTION&gt; &lt;FILTERABLE&gt;true&lt;/FILTERABLE&gt; &lt;REPEATABLE&gt;false&lt;/REPEATABLE&gt; &lt;REPEATEDBASE&gt;false&lt;/REPEATEDBASE&gt; &lt;/COLUMN&gt;&lt;/COLUMNLIST&gt; My guess would be that these are both in microseconds and they don’t get the same microsecond to millisecond conversion that the normal duration column does in Profiler. I’d have to stack walk the processing to validate this 100% from the callstack frames, but the numbers look to be microseconds equating to 1.2 second executions, unless you were replaying long running processes that took 20 minutes to replay which would be what the 1.2 million millisecond durations would equate to. Which one do you use? It depends on whether you want to include the fetch time to send the result over the network as a part of your metric or not. I’d probably rely on ExecutionTime for server side processing tracking depending on what I was trying to compare.Thu, 12 Sep 2013 14:37:53 GMTcurious_sqldbaRE: Interpret Output of TSQL_Replay tracehttp://www.sqlservercentral.com/Forums/Topic1492989-146-1.aspx[quote][b]//Ravi (9/10/2013)[/b][hr]The "Duration" column in the Profiler. In SQL 2008, it shows the timings in Microseconds (i.e. divide by a million to get seconds) and in SQL 2005, it shows the execution time in Milli Seconds. There is also a StartTime and EndTime column. You can export the data into a table and then manipulate data using t-sql. You can either display "Duration" Column in seconds or subtract EndTime with StartTime. Hope this help. See the image attached.[/quote]Thanks for the response. Yeah i got that part, so when i replay at the bottom there are two columns ExecutionTime and ExecutionAndFetchTime, which ones should we consider as run times in test environment and is that in MS or S? Attached image has more details.Tue, 10 Sep 2013 16:30:07 GMTcurious_sqldbaRE: Interpret Output of TSQL_Replay tracehttp://www.sqlservercentral.com/Forums/Topic1492989-146-1.aspxThe "Duration" column in the Profiler. In SQL 2008, it shows the timings in Microseconds (i.e. divide by a million to get seconds) and in SQL 2005, it shows the execution time in Milli Seconds. There is also a StartTime and EndTime column. You can export the data into a table and then manipulate data using t-sql. You can either display "Duration" Column in seconds or subtract EndTime with StartTime. Hope this help. See the image attached.Tue, 10 Sep 2013 14:06:50 GMT//RaviInterpret Output of TSQL_Replay tracehttp://www.sqlservercentral.com/Forums/Topic1492989-146-1.aspxCan someone please tell me which column provides the actual execution timings based on the output from TSQL_Replay trace?Mon, 09 Sep 2013 23:30:57 GMTcurious_sqldba