| title | titleSuffix | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.collection | |
|---|---|---|---|---|---|---|---|---|---|---|
Replay a Single Event at a Time |
(SQL Server Profiler |
Discover how to replay one trace event at a time in SQL Server Profiler by stepping through a replay trace file or table. |
rwestMSFT |
randolphwest |
03/01/2017 |
sql |
profiler |
how-to |
|
[!INCLUDE SQL Server Azure SQL Managed Instance]
This topic describes how to replay one event at a time in a replay trace file or table by using [!INCLUDEssSqlProfiler].
-
Open the trace file or trace table you want to replay. For more information, see Open a Trace File (SQL Server Profiler) or Open a Trace Table (SQL Server Profiler).
Make sure that the trace file or table you open contains the event classes necessary for replay. For more information, see Replay Requirements.
-
On the Replay menu, click Step, and connect to the server instance where you want to replay the trace.
-
In the Replay Configuration dialog box, verify the settings, and then click OK. For more information about specifying settings on the Replay Configuration dialog box, see Replay a Trace File (SQL Server Profiler) or Replay a Trace Table (SQL Server Profiler).
-
To replay the first event, click OK in the Replay Configuration dialog box.
-
To replay subsequent events, on the Replay menu, click Step, or press F10. Repeat clicking Step or pressing F10 for each event.