Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
On the File menu, point to Open, and then select 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, select Start, and connect to the server where you want to replay the script.
In the Replay Configuration dialog box, verify the settings, and then select OK.