Skip to content

filter-events-based-on-the-event-end-time-sql-server-profiler.md

Latest commit

 

History

History
41 lines (27 loc) · 1.88 KB

filter-events-based-on-the-event-end-time-sql-server-profiler.md

File metadata and controls

41 lines (27 loc) · 1.88 KB
title Filter Events Based on the Event End Time
titleSuffix SQL Server Profiler
description Filter events by ending time during a trace. Learn how to set up a filter on the event ending time in SQL Server Profiler.
author rwestMSFT
ms.author randolphwest
ms.date 06/05/2025
ms.service sql
ms.subservice profiler
ms.topic how-to
ms.collection
data-tools

Filter events based on the event end Time (SQL Server Profiler)

[!INCLUDE SQL Server Azure SQL Managed Instance]

This article describes how to filter trace events based on the event ending time by using [!INCLUDE ssSqlProfiler].

Filter events based on the event end time

  1. On the File menu, select New Trace, and then connect to an instance of [!INCLUDE ssNoVersion].

    The Trace Properties dialog box appears.

    If Start tracing immediately after making connection is selected, the Trace Properties dialog box fails to appear and the trace begins instead. To turn off this setting, on the Tools menu, select Options, and clear the Start tracing immediately after making connection check box.

  2. In the Trace Properties dialog box, make sure the General tab is selected, and enter a name in the TraceName text box.

  3. From the Use the template list, select a trace template.

  4. Optionally, specify a destination file or table in which to save the trace results.

  5. On the Events Selection tab, select the EndTime data column to launch the Edit Filter dialog box. You can also right-click the column heading, and select Edit Column Filter.

  6. Expand Greater than or Less than, and enter a datetime value in the field that appears beneath the comparison operator.

Related content