Post reply

How to match replay results with trace file?

  • April 11, 2018 at 7:51 am

    #336972

    Hello,

    I captured a trace into an SQL table with SQL Profiler and template TSQL_Replay. I replay now this trace and I choose to have the trace results saved into an SQL table. Some results indicate that there was an error.

    How do I find, which event produced the error? Unfortunately in the replay results, the column EventSequence is not included. Is there an option to have the column EventSequence be included in the replay results, or is there some other way to match replay results with trace events?

  • May 4, 2018 at 7:52 am

    #1989283

    Can't you see it in the GUI? The rows with errors are displayed in red with a Replay Provider Error
    I tested a replay myself, and error seems to get EventClass 63485 inside the result table, so you can see which queries were ran exacly before the error by checking the rownumber.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply