Replay a Transact-SQL script (SQL Server Profiler)

Applies to: SQL Server Azure SQL Managed Instance

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.

Replay a Transact-SQL script

1. On the File menu, point to Open, and then select Script File.

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 Replay menu, select Start, and connect to the server where you want to replay the script.

4. In the Replay Configuration dialog box, verify the settings, and then select OK.

Related content

• Replay Traces
• SQL Server Profiler