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

title	Replay a Transact-SQL Script (SQL Server Profiler) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.prod_service	sql-non-specified
ms.service
ms.component	sql-server-profiler
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	article
helpviewer_keywords	traces [SQL Server], replaying scripts [SQL Server], traces replaying traces
ms.assetid	9c0eb222-e6e3-4bc1-a25f-a41e962d361b
caps.latest.revision	24
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard
ms.workload	Inactive

Replay a Transact-SQL Script (SQL Server Profiler)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] 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