How to replay a trace file (SQL Profiler)

To replay a trace file

1. On the File menu, point to Open, and then click Trace File.
   
   
2. Select the file to open.
   
   
3. On the Replay menu, click Start.
   
   
4. In the Connect to SQL Server dialog box, select the server to connect to and a connection method.
   
   
5. In the Replay SQL Server dialog box, select the destination server, and then select any of the following:
   • Replay events in the order they were traced
     
     
   • Replay events using multiple threads
     
     
   • Display replay results