Skip to content

Latest commit

 

History

History
35 lines (24 loc) · 1.57 KB

replay-a-transact-sql-script-sql-server-profiler.md

File metadata and controls

35 lines (24 loc) · 1.57 KB
title titleSuffix description author ms.author ms.date ms.service ms.subservice ms.topic ms.collection
Replay a Transact-SQL Script
SQL Server Profiler
Discover how to use SQL Server Profiler to replay Transact-SQL scripts so that you can compare different possible solutions to a performance problem.
rwestMSFT
randolphwest
03/14/2017
sql
profiler
how-to
data-tools

Replay a Transact-SQL Script (SQL Server Profiler)

[!INCLUDE SQL Server Azure SQL Managed Instance]

When you test possible solutions to a performance problem, use [!INCLUDEssSqlProfiler] to replay [!INCLUDEtsql] scripts, and compare performance before and after your changes.

To replay a Transact-SQL script

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

  2. Select the [!INCLUDEtsql] script file you want to open. Make sure that the [!INCLUDEtsql] script contains events necessary for replay. For more information, see Replay Requirements.

  3. On the Replay menu, click 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 click OK.

See Also

Replay Traces
SQL Server Profiler