Skip to content

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

Latest commit

 

History

History
37 lines (29 loc) · 1.61 KB

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

File metadata and controls

37 lines (29 loc) · 1.61 KB
title Replay a Transact-SQL Script (SQL Server Profiler) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service sql-tools
ms.reviewer
ms.technology profiler
ms.topic conceptual
helpviewer_keywords
traces [SQL Server], replaying
scripts [SQL Server], traces
replaying traces
ms.assetid 9c0eb222-e6e3-4bc1-a25f-a41e962d361b
author markingmyname
ms.author maghan
manager craigg

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