Skip to content

replay-to-a-cursor-sql-server-profiler.md

Latest commit

 

History

History
43 lines (29 loc) · 1.86 KB

replay-to-a-cursor-sql-server-profiler.md

File metadata and controls

43 lines (29 loc) · 1.86 KB
title Replay to a Cursor
titleSuffix SQL Server Profiler
description Discover how to use a cursor in SQL Server Profiler to pause a trace replay at a specific point. Make debugging easier by replaying to a cursor.
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 to a cursor (SQL Server Profiler)

[!INCLUDE SQL Server Azure SQL Managed Instance]

This article describes how to replay trace files or tables that pause when a cursor is reached by using [!INCLUDE ssSqlProfiler]. Pausing traces at cursors supports debugging because you can break the replay of long trace scripts into short segments that can be analyzed incrementally.

Replay to the cursor

  1. Open the trace file or trace table you want to replay. For more information, see Open a trace file (SQL Server Profiler) or Open a trace table (SQL Server Profiler).

    Make sure that the trace file or table you open contains the event classes necessary for replay. For more information, see Replay Requirements.

  2. In the trace window, select an event.

  3. On the Replay menu, select Run to Cursor, and then connect to the server where you want to replay the trace.

  4. In the Replay Configuration dialog box, verify the settings, and then select OK.

    The replay starts, pausing when the first cursor is reached.

  5. Press F5 to resume the trace.

  6. Repeat Step 5 through the end of the trace.

Related content