Skip to content

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

Latest commit

 

History

History
34 lines (24 loc) · 1.45 KB

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

File metadata and controls

34 lines (24 loc) · 1.45 KB
title Replay a Transact-SQL Script
titleSuffix SQL Server Profiler
description Discover how to use SQL Server Profiler to replay Transact-SQL scripts so that you can compare different possible solutions to a performance problem.
author rwestMSFT
ms.author randolphwest
ms.date 06/05/2025
ms.service sql
ms.subservice profiler
ms.topic how-to
ms.collection
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 [!INCLUDE ssSqlProfiler] to replay [!INCLUDE tsql] 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 [!INCLUDE tsql] script file you want to open. Make sure that the [!INCLUDE tsql] 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