Skip to content

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

Latest commit

 

History

History
62 lines (45 loc) · 2.96 KB

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

File metadata and controls

62 lines (45 loc) · 2.96 KB
title Replay to a Breakpoint (SQL Server Profiler) | Microsoft Docs
ms.custom
ms.date 03/01/2017
ms.prod sql-non-specified
ms.prod_service sql-tools
ms.service
ms.component sql-server-profiler
ms.reviewer
ms.suite sql
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
breakpoints [SQL Server]
traces [SQL Server], replaying
ms.assetid 3caf751e-df3b-40c7-b5e8-4490ae178e0c
caps.latest.revision 25
author stevestein
ms.author sstein
manager craigg
ms.workload Inactive

Replay to a Breakpoint (SQL Server Profiler)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] This topic describes how to set breakpoints in a trace file or table that you want to replay by using [!INCLUDEssSqlProfiler]. Setting breakpoints in a trace file or table before you start to replay the trace, enables you to pause replay of the trace at specific events. Using breakpoints while replaying a trace supports debugging because you can break the replay of long trace scripts into short segments that can be analyzed incrementally.

To replay to a breakpoint

  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, click an event that you want to use as a breakpoint. Use one of the following three methods to set a breakpoint:

    • Press F9.

    • On the Replay menu, click Toggle Breakpoint.

    • Right-click the event, and then click Toggle Breakpoint.

    A red bullet appears next to the selected trace event, indicating that it is the trace breakpoint.

    Repeat this step to set several breakpoints.

  3. On the Replay menu, click Start, and connect to the server where you want to replay the trace.

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

    The replay starts, pausing when the breakpoint is reached.

  5. Press F5 to resume the replay and proceed to the next breakpoint.

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

See Also

Replay to a Cursor (SQL Server Profiler)
Replay Traces
SQL Server Profiler