Skip to content

Latest commit

 

History

History
43 lines (28 loc) · 1.89 KB

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

File metadata and controls

43 lines (28 loc) · 1.89 KB
title titleSuffix description author ms.author ms.date ms.service ms.subservice ms.topic ms.collection
Filter Events Based on the Event Start Time
SQL Server Profiler
Filter events by start time during a trace. Learn how to set up a filter on the event start time in SQL Server Profiler.
rwestMSFT
randolphwest
03/14/2017
sql
profiler
how-to
data-tools

Filter Events Based on the Event Start Time (SQL Server Profiler)

[!INCLUDE SQL Server Azure SQL Managed Instance]

This topic describes how to filter trace events based on the event start time by using [!INCLUDEssSqlProfiler].

To filter an event based on the event start time

  1. On the File menu, click New Trace, and then connect to an instance of [!INCLUDEssNoVersion].

    The Trace Propertiesdialog box appears.

    [!NOTE]
    If Start tracing immediately after making connectionis selected, the Trace Propertiesdialog box fails to appear, and the trace begins instead. To turn off this setting, on the Toolsmenu, click Options, and clear the Start tracing immediately after making connection check box.

  2. In the Trace name box, type a name for the trace.

  3. In the Use the templatename list, select a trace template.

  4. Optionally specify a destination for the trace results.

  5. On the Events Selectiontab, click the StartTime column heading. You can also right-click the column heading, and then click Edit Column Filter to launch the Edit Filter dialog box.

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

See Also

SQL Server Profiler