How to: Replay a Transact-SQL Script (SQL Server Profiler)
SQL Server 2005
When you test possible solutions to a performance problem, use SQL Server Profiler to replay Transact-SQL scripts, and compare performance before and after your changes.
-
On the File menu, point to Open, and then click Script File.
-
Select the Transact-SQL script file you want to open. Make sure that the Transact-SQL script contains events necessary for replay. For more information, see Replay Requirements.
-
On the Replay menu, click Start, and connect to the server where you want to replay the script.
-
In the Replay Configuration dialog box, verify the settings, and then click OK.
