Hello,

I am been trying to do a replay trace to get some performance statistics for a migration. We are going from a physical server to VM and the application team is concerned about the performance.

Question:

I ran the replay trace to capture the events on the current prod server . After capturing the data I loaded into a table and I get a column Duration which tells me how much time the particular query ran. I loaded the trace into a table and the Unit for Duration column is changed to Microseconds.

Now I replayed the trace on the new server where we are migrating to and trace did run fine. I loaded the info into a table so that I can query . and there is a column called Execution time .

Question I have is, is the Duration  and ExecutionTime in the replay trace means the same ?

Thanks,

I think its same. It calls the column in terms of execution time in Target server and a different way in Source.

the unit value of duration is Microsecond when it is loaded in a table. But at least from the test and comparisons in our environment it looks like the execution time column unit looks to be still in millisecond when loaded into a table.

Not finding any supporting document to prove this though.

Thanks,