| title | Replay a Single Event at a Time |
|---|---|
| titleSuffix | (SQL Server Profiler |
| description | Discover how to replay one trace event at a time in SQL Server Profiler by stepping through a replay trace file or table. |
| ms.prod | sql |
| ms.prod_service | sql-tools |
| ms.reviewer | |
| ms.technology | profiler |
| ms.topic | conceptual |
| ms.assetid | 220fb192-9636-41a2-b15c-62af6cab8fff |
| author | markingmyname |
| ms.author | maghan |
| ms.custom | seo-lt-2019 |
| ms.date | 03/01/2017 |
[!INCLUDE SQL Server]
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.