Replay a T-SQL Script

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.

1. On the

menu, point to

, and then select.

2. 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.

3. On the

menu, select

, and connect to the server where you want to replay the

script.

4. In the

dialog box, verify the settings, and then select.

Replay Traces

Profiler